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

help with a report..

P: n/a
Ok.. I have a table where people add and delete records when machines
are sold or new ones brought into inventory. I know.. this isn't a good
business practice, but thats how they do it.

What I need is snapshots of the table on a specified day each month,
and queries comparing the 2 in order to get a list of Removed and Added
Records.

the queries are easy enough, but I have to remember to copy the latest
table as NewPopulation and the NewPopulation from last month as
LastPopulation before I run each query. This is kind of a pain and was
wondering if there was a way to put something like [enter table name]
in a query to select whatever table I wanted to use.

te**@conwaycorp.net

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


P: n/a
Yes, I definitely agree that it is not a good practice to delete the records
when the machines are sold. You lose historical data that could be very
valuable in analyzing your business and planning for the future.

You can use Make Table Queries to copy the table, using the date/time as
part of a constructed name for the new table, based on your VBA code
comparing date/time (not necessarily trivial, but doable without "advanced
mathematics). You can use Windows scheduling to run your Access application
at dates and times of your choosing with Command Line parameters to run
specific macros that initiate these processes.

If you also have identical data, or data so similar that you need to specify
the table name to select the information you need, you likely have other
design issues that should be addressed, as well. You can use [Enter
somethingorother] to prompt for criteria on Fields; but that does not extend
to specifying the Table Name. You'll need to write, or have written, VBA
code to do what you want, I believe.

Perhaps if you could clarify your table layout and structure, someone could
offer more specific advice.

Larry Linson
Microsoft Access MVP
<te**********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Ok.. I have a table where people add and delete records when machines
are sold or new ones brought into inventory. I know.. this isn't a good
business practice, but thats how they do it.

What I need is snapshots of the table on a specified day each month,
and queries comparing the 2 in order to get a list of Removed and Added
Records.

the queries are easy enough, but I have to remember to copy the latest
table as NewPopulation and the NewPopulation from last month as
LastPopulation before I run each query. This is kind of a pain and was
wondering if there was a way to put something like [enter table name]
in a query to select whatever table I wanted to use.

te**@conwaycorp.net

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.