Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Should a report be based on a Table or a Query?

Status
Not open for further replies.

JMM

Technical User
Feb 17, 2000
37
NZ
I am extracting a range of info from one table to produce a number of reports. The database is networked with the table on the server in the back-end.

Should these reports be based on the table or on a query which is in the local front-end?

Thanks in advance [sig][/sig]
 
I generally favor using the table in this situation. If there is any sorting/grouping in the report, the report will 'virtually' run a query to sort the records, so adding another query just 'prolong' the processing.
[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top