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

MS Access 2000 + Table + Report

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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...

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.