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

[keshmon]

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?

[twinnyfo]

keshmon,

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.