Microsoft Access 2003 - How to Get New Data on an Existing Report

[txdave35]

Hey guys,

I have an Access file for printing 1099 forms. The file contains a report for 1099. I need the same report to print out, but with new data from my Excel spreadsheet.

So I did a data import and brought the data, and over wrote the previous tables. The tables now have the same name as before, but with the new data.

However, when I run my report, it still displays the old data. The file does have append queries, but when I run the query, I get:

The INSERT INTO statement contains the following uknown field, PAYER. PAYER is a valid field name.

So I puzzled here. IS there a way to see exactly where the query is getting hung up at? Thanks.

 

[genomon]

PAYER is a valid field name

Yes, but that doesn't mean it made it onto the new table, or that it's spelled correctly everywhere.
If your query is in VBA, try breakpointing and stepping thru your code. If not, paste the SQL into the QBE and try running it from there.

Ever notice how fast Windows runs? Me neither.