MS Access 2000 + Table + Report

[kylei]

I need to create a report for a monthly sales table that is sent to our
company. Is there a way to create a report that will automatically sum
totals from a file that is sent to us every month? Every month a
different file is sent but it is in the same format but with different
data. If so, where do I start?

[pietlinden]

1. delete contents of destination table. (run a canned delete query)
2. append new records to table. (import or whatever)
3. create report as you want it to look. (include totals etc)
4. run report.

you might want to include a field in your table that contains a
datestamp or whatever of when the data was imported, and then you can
just filter on that. That way, you can run ANY report whenever you
want. (so you'd skip the delete stuff.)
You might want to start by making friends with the help files...