Generating Monthly Report in MS ACCESS

  • Thread starter Thread starter Sahil
  • Start date Start date
S

Sahil

I am creating a database in MS ACCESS for data-entry
of records, where the system should track the date of
record entry. I am using the function date() to track
the user entry date, which automatically saves the
system date in short date format (1/15/2003) as soon
as the user saves the record.
Please note that the form "Batch Details" saves the
record entries in the table "Batch". I have a field
"Entry_date" in the table "Batch" which tracks the
date of user entry in the format MM/DD/YYYY. I have
another form FrmDate where user has the combox box
with the names of the months. Now my requirement is to
generate a report displaying all the fields from the
table "Batch" where the month is the one which the
user selects. If the user selects "January", the
report should pull up the all the fields where the
Entry_date is between 1/1/2004 to 1/31/2004. I hope
this is clear. Thanks for your help.
 
Sahil,

Base your report on a query. In the query, make a calculated field
like this...
EntryMonth: Format([Entry_date],"mmmm")
.... and in the criteria of this field in the query, put...
[Forms]![FrmDate]![NameOfYourCombobox]

Only problem with this is what happens when you have more than one
year's data in the system, you will need a way to also designate year
as well as month.

- Steve Schapel, Microsoft Access MVP
 
Dear Steve,

It worked. Thank you very much for your help.
I do understand the limitation about the "year", I will
try to work out that. Meanwhile, I will keep coming back
to the Newsgroup in case I get stuck with something else.

Thanks again.

Sahil
-----Original Message-----
Sahil,

Base your report on a query. In the query, make a calculated field
like this...
EntryMonth: Format([Entry_date],"mmmm")
.... and in the criteria of this field in the query, put...
[Forms]![FrmDate]![NameOfYourCombobox]

Only problem with this is what happens when you have more than one
year's data in the system, you will need a way to also designate year
as well as month.

- Steve Schapel, Microsoft Access MVP


I am creating a database in MS ACCESS for data-entry
of records, where the system should track the date of
record entry. I am using the function date() to track
the user entry date, which automatically saves the
system date in short date format (1/15/2003) as soon
as the user saves the record.
Please note that the form "Batch Details" saves the
record entries in the table "Batch". I have a field
"Entry_date" in the table "Batch" which tracks the
date of user entry in the format MM/DD/YYYY. I have
another form FrmDate where user has the combox box
with the names of the months. Now my requirement is to
generate a report displaying all the fields from the
table "Batch" where the month is the one which the
user selects. If the user selects "January", the
report should pull up the all the fields where the
Entry_date is between 1/1/2004 to 1/31/2004. I hope
this is clear. Thanks for your help.
Click to expand...

.
Click to expand...
 
Back
Top