Generating Monthly Report in MS ACCESS

[sahil]

Hi,

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 (12/24/2003) as soon as the user
saves the record. I need help for generating of reports, I have a form
where the user is given the check box to select the month for which he
needs to pull up the details; suppose the user wants the details of the
records entered in the month December, the system should display all
the records entered between 12/01/2003 to 12/31/2003 in a report.
Please help if this is possible in MS ACCESS.

 

[John Vinson]

Hi,

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 (12/24/2003) as soon as the user
saves the record.

Well, actually that's not true. It saves the date as a Double Float
number, a count of days since midnight, December 30, 1899. The format
is irrelevant to what's stored; it just sets how that value is
displayed by default. You can set the format of the field to anything
you want among the plethora of date formats.

I need help for generating of reports, I have a form
where the user is given the check box to select the month for which he
needs to pull up the details; suppose the user wants the details of the
records entered in the month December, the system should display all
the records entered between 12/01/2003 to 12/31/2003 in a report.
Please help if this is possible in MS ACCESS.

Sure. I'd put twelve checkboxes into an Option Group control named
optMonth, and assign the January checkbox the value 1, February 2,
...., Decemeber 12.

You can then use a Query based on your table with a criterion on the
datefield of

= DateSerial(Year(Date()), Forms![formname]![optMonth], 1)

AND < DateSerial(Year(Date()), Forms![formname]![optMonth] + 1, 1)

Note that as phrased the question does not specify which YEAR you want
returned - this code assumes the current year.

 

[bomantas]

Hi I have the same problem and don't quite understand the response
posted above. I did what was written and managed to make some headway
and can now sort and display my records all according to a specific
month when I type in the corresponding number (December = 12).
However, what if I have other criteria that I want to help further sort
my records? Do I do the same thing or is there any other way?