How can I populate a field with data from another field?

C

Crazy Lady

Once a month, I want to update a field with data from another field. Both
sets of data are currently in a query and on a form. The first field (the
one being updated) will form part of a report.

Also, I want to save my data monthly before the update takes place. Can I
do that and how?
 
R

Rick B

Does not sound like a normalized thing to do. What data are you trying to
store/move?
 
W

Wayne Morgan

Can you? Yes, but why? Just use filters on the query (WHERE clause in SQL or
Criteria in the design grid) feeding the report to limit the records
returned to the desired records. You can set these up as Parameters to be
filled in with the current date or other changing data you may need to get
the correct records for the report.
 
Top