No current record; small test file No, big file yes

[LexKuijt]

I try to run a query which consists of several others.
When I run it with a small test table (12.000 records) I do not get the message. When running with a production table (1.300.000 records) I do get the message. It only happens when I link a final extra query where I link the tables by fields that are calculated values.

Why not with the test table and why I do get the message with the big table?

 

[isladogs]

The obvious but unhelpful answer is that the situation is in some way different for the two cases. However, without more details from you about the query sql and your data, any suggestions would just be guesswork.

Welcome to the forum BTW

 

[Pat Hartman]

There also might be a data problem. Can you try selecting different sets of data to see if you can narrow down where the problem might be?

 

[The_Doc_Man]

I try to run a query which consists of several others.

...

It only happens when I link a final extra query where I link the tables by fields that are calculated values.

At the risk of stating the obvious, I would look really hard at that final extra query.

Also, either you are doing something odd with tables or your choice of words is a bit loose. Calculated fields are fine in queries but somewhat of a problem for tables.

Sampling theory says that with 12,000 test records vs. 1.3 million records, you have approximately a 10% chance (rounded off a bit) that those samples (if chosen randomly) will completely test the main sample. And given the size of the test sample, odds are pretty good in my book that you didn't hand-build the sample set. So that means you have a 90% chance that your test sample doesn't test everything.

I'm with Pat on the idea of selecting a different test set.

 

[Mark_]

Copy production tables to test database.

Rerun queries.

If all work fine then you have an issue with your production database.
If you have the same problem, step through each query until you find the one that does not return data. Look at what its criteria is and check the underlying queries return to see what your problem is.

Example;
If your sample data is all from 2015, but none of your production data is, then any query looking for "All sales in 2015" WILL work on your sample data but NOT on your production data.