P
PattiP
I'm keeping track of monthly meter readings with a sample of 6 accounts. I
have created an append query that copies the previous month's accounts to the
table and puts last month's current reading into this month's previous
reading column and leaves the current reading with zeros or blank. I'm using
the Month field and a parameter query to enter last month’s date (ex: 4/1/08)
as the criteria in the query. This all works great. However, when the new
records are created, they are also showing 4/1/08 in the Month field. I
would like the new records to show this month’s date (5/1/08) so I don’t have
to re-enter them. Can I do that in the same append query, or do I have to
create an update query and run both? I would like it all to be in one step,
if possible.
have created an append query that copies the previous month's accounts to the
table and puts last month's current reading into this month's previous
reading column and leaves the current reading with zeros or blank. I'm using
the Month field and a parameter query to enter last month’s date (ex: 4/1/08)
as the criteria in the query. This all works great. However, when the new
records are created, they are also showing 4/1/08 in the Month field. I
would like the new records to show this month’s date (5/1/08) so I don’t have
to re-enter them. Can I do that in the same append query, or do I have to
create an update query and run both? I would like it all to be in one step,
if possible.