Thanx Bill,..
Yes, that is the point,,,the query that i want to join with is a rather complex query and use agregate function (??? - is Group By feature a aggregate function ?)
I.ve read that using aggregate function make query slow to open,,,so in my case what should i do ? make it table first or not ?.
In my opinion is better if i join the query direct to the Main Table, not make table process first,..
For now both technique give the same time result to process because not many datas in there, but i affraid if next time the datas more and more...
________________________________
Dari: Bill Mosca <wrmosca@comcast.net>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Kamis, 2 Februari 2012 9:03
Judul: RE: [MS_AccessPros] Which is better?
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]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar