Jim,
What I do is have a subquery that has all the fields/tables/relationships you need without the criteria, and then have your vba code set the querydef.sql of an inner join query that establishes the criteria.
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Tuesday, July 16, 2013 9:06 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Query Performance question
Hello all,
I have a question about query performance.
What would be faster to use for a report?
I have several reports that are based on the same multi table query, but with different criteria across the grid. It would be almost like a View in SQL.
Thank You
Jim Wagner
A query with 3 tables in the design view with the criteria in the grid
OR
A Make table query that has all the tables and criteria being used for the source of the report
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar