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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Does not sound like a normalized thing to do. What data are you trying to
store/move?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populating fields from another table 3
Populate combo box from current record 3
Auto populate fields 5
Sum 4 Fields with conditions 4
Retrieving data from subform 1
How to calculate form field 1
Updating tables when you input new data 0
Auto Populate a field 0

Back
Top