ACCESS FEED: RE: [MS_AccessPros] Which is better?

Rabu, 01 Februari 2012

Hendra

The very nice thing about Access is you can use a query as a table. In other
environments this would be called a view. There is no reason to make a table
first unless the query is complex and takes a long time to load.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile/Bill.Mosca>
https://mvp.support.microsoft.com/profile/Bill.Mosca

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Wednesday, February 01, 2012 4:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Which is better?

Hi Everyone...

If we want to join a table (as one side) to a query (as many side), is better
idea to make the query to table first? (using Query Make Table)...or it's better
if we join the table dirrect to the query.
Note that the query used Group By feature and it's a complex query builded from
many tables...

Regards
Hendra

[Non-text portions of this message have been removed]