By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,728 Members | 1,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,728 IT Pros & Developers. It's quick & easy.

Reloading/appending records in a table results in fewer records than before

P: 1
While running a macro, four reports are being generated. One of the report shows 1000+ records which is incorrect and when I delete the records from that table and reload/append those 1000+ records, on running that particular query of the report, it shows me correct no of records which is less than 100.

Can anybody help me explain what is the problem with my module?
Jun 4 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,486

My guess is that whatever is generating the 1000+ records in that tables (whether it is an append Query or something similar) is not grouping correctly.

However, without greater details as to how your DB is set up and what types of queries are creating waht types of data, we can't be sure.

If you could provide some examples of what your are doing, we can try to trouble shoot as best we can.
Jun 9 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.