multi-field query

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
I have a select query that consist alot of tables and fields,that
issue is making the proccess heavier
is it posible to make it faster then its current stage?otherwise i
need to run a make-table query that will build a table but this
proccess will blow the file size
any ideas?
 
thread said:
Hi all,
I have a select query that consist alot of tables and fields,that
issue is making the proccess heavier
is it posible to make it faster then its current stage?otherwise i
need to run a make-table query that will build a table but this
proccess will blow the file size
any ideas?
Click to expand...

I doubt if making a new table is going to help you, but without knowing
a lot more about your current design I don't think anyone can really guess.
 
it accually helps becaouse its just taking data from one table and
when its pulling data its just using one table data instead of 10-12
tables in a query

Joseph Meehan כתב:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comment before opening hybrid query 1
Buidling query inside of a query using docmd.RunSQL. 1
Stucked screen 3
select query taking too long 2
union queries - with tables containing fields with attachments 2
calculation mode 9
Query about an append query 1
Data Mismatch in Excel 2010 4

Back
Top