oh snaps June7, it works perfect.
Thanks so a ton for your help.
oh snaps June7, it works perfect.
Thanks so a ton for your help.
Hi June7,
I had marked this post as solved, and it is, i just have one little hang up.
i took your advice from post 9, and added the concat function on 1qry_UniqueOperators, the problem is when i try to run the query, it gets hung up; takes forreeevvverrrr to load.
given, the db is on a network, but it shoudlnt take THAT long to load (sometimes 10+ mins).
is there anything i could do with the query to speeds this up a tiny bit?
maybe truncate the query with the dates im interested in?
the query that feeds the report, 1qry_rptInspectionShiftYield, does have a between dates criteria.
I've never had to use this function for my data. I don't know if it could be any faster. When I run your query from my laptop it takes about 4 seconds, which is a little slow for 346 records. I will take to work tomorrow and run from network server and see what happens.
Last edited by June7; 03-29-2012 at 12:14 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Tested at work, takes 6 seconds to run. So does the Glassing Inspection Shift Yield report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
hmmmm i have 24,000 records on a network :S
it gets hung up.
Can you test a copy on local drive?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
yep, i did, it is a little faster.
one thing i did was create a "in between dates" criteria for for the queries using that concat function; that way the function only works through those records and not every record in the table.
this has made it much faster.