Why does my access report print too many records?

[Guest]

Ihave created a macro to import an excel spreadsheet with a list of Postcodes
into tblMain1 which is linked to tblPostcode Locations on a one to one join
my report takes Postcode from tblMain1 and X and Y from tblPostcode
Locations. Then i told the macro to print the report. As I am just trying
it I have imported several different batches through the same excel sheet.
The report seems to print all off the records with out deleting the old
records.

I suppose I am asking how do I clear the report each time after I am finished?
Thanx
Liz

 

[Guest]

I am assuming all of the records appear in your underlying tables, for the
multiple batch loads? Sounds like you would need to clear the records from
your table before each new load. Am I understanding you correctly?

 

[Steve Schapel]

Liz,

It sounds to me like you need to set up a Delete Query to remove all
records from tblMain1 table after you have finished the report and/or
before you import the next batch from Excel. You can use an OpenQuery
action in your macro to run the delete query.