T
Thorson
This is a repost, here is my original problem (this is long... my new
question is at the bottom):
------------------
We are required to keep records of any movement of animals from one location,
deaths of animals, births, new animals entering etc. I have separate tables
set up to enter all of this information.
A report is then generated in the database each month that reports all
movement of animals and a total animal inventory. It reports the total
number of animals at the beginning of the month, end of the month and all the
changes.
The problem is when a correction needs to be made to a previous month's
report. Instead of entering in the record like it happened that month and
going back to change all the following reports(the inventory numbers are
affected) I need the report to pull up the new record in the month the
correction was "discovered" no matter when it actually happened.
For example, if an animal was born in January but there was a mistake and it
was not recorded until March I want the birth to show up on the March report
as a correction from January.
Right now the report just pulls from dates such as the birthdate, the date
the animal died or was purchased etc. I think putting a "entry date" column,
therefore automatically entering the date the record was recorded and setting
the queries to pull records based on the entry date would work. The problem
with pulling the records is that the records may be entered up to 5 days
after the end of the month, however new records for the next month may also
be entered at that time.
------------------
Someone gave me a suggestion to create a field that tracks the date the
record was entered and draw up my query from that, which I think will solve
my problem but now I have this question:
okay, So I haven't had much time to look at this until now. I think it will
work though. I currently have a form that the user fills out to pull a
report with all the records that occurred in a given month. It looks like
(using your code) I can limit that to the date they were entered (so if a
record occurred in May but wasn't entered until July it wouldn't show up
until the July report.)
I have very little experience with coding. I currently just have the user
enter in the "month" and "Year", could I have the Date from be the first day
of that month and the date two be the 5th day of the next month?
question is at the bottom):
------------------
We are required to keep records of any movement of animals from one location,
deaths of animals, births, new animals entering etc. I have separate tables
set up to enter all of this information.
A report is then generated in the database each month that reports all
movement of animals and a total animal inventory. It reports the total
number of animals at the beginning of the month, end of the month and all the
changes.
The problem is when a correction needs to be made to a previous month's
report. Instead of entering in the record like it happened that month and
going back to change all the following reports(the inventory numbers are
affected) I need the report to pull up the new record in the month the
correction was "discovered" no matter when it actually happened.
For example, if an animal was born in January but there was a mistake and it
was not recorded until March I want the birth to show up on the March report
as a correction from January.
Right now the report just pulls from dates such as the birthdate, the date
the animal died or was purchased etc. I think putting a "entry date" column,
therefore automatically entering the date the record was recorded and setting
the queries to pull records based on the entry date would work. The problem
with pulling the records is that the records may be entered up to 5 days
after the end of the month, however new records for the next month may also
be entered at that time.
------------------
Someone gave me a suggestion to create a field that tracks the date the
record was entered and draw up my query from that, which I think will solve
my problem but now I have this question:
okay, So I haven't had much time to look at this until now. I think it will
work though. I currently have a form that the user fills out to pull a
report with all the records that occurred in a given month. It looks like
(using your code) I can limit that to the date they were entered (so if a
record occurred in May but wasn't entered until July it wouldn't show up
until the July report.)
I have very little experience with coding. I currently just have the user
enter in the "month" and "Year", could I have the Date from be the first day
of that month and the date two be the 5th day of the next month?