H
hom370
I need to run an append query when I open my db so it can look at the dates
in some records and copy records where the date is >=[periodenddate] and some
other criteria.
But the records still need to have some code run on them to set up fields in
the new records that should not be copied from the old records. It is mostly
math and date manipulation using values in some fields to compute with and
write the results to other fields. The code that needs to be run is in
various places behind the form I use to manually set up the records.
What I'm trying to do here is automate the creation of some of the records.
How do go about getting the results I'm needing?
Thank you.
in some records and copy records where the date is >=[periodenddate] and some
other criteria.
But the records still need to have some code run on them to set up fields in
the new records that should not be copied from the old records. It is mostly
math and date manipulation using values in some fields to compute with and
write the results to other fields. The code that needs to be run is in
various places behind the form I use to manually set up the records.
What I'm trying to do here is automate the creation of some of the records.
How do go about getting the results I'm needing?
Thank you.