Selecting Records base on current month

[nancy]

I have a report that select info base off of a query.
I would like to have the report show infomation that is from a selected
month and year.

I have a simple check in system for volunteers. The date is automatically
enter into a column called wlDate. The date is listed as mm/dd/yyyy

How Do I do this.

 

[Brad]

Hi Nancy,

You could create another field in your query called MonthDate and format it
to only show the Month and the Date. Then you could filter the data set in
the query, or you could add the field as hidden to your report and filter it
there.

Brad

 

[nancy]

How do I format the field to show the month?

Hi Nancy,

You could create another field in your query called MonthDate and format it
to only show the Month and the Date. Then you could filter the data set in
the query, or you could add the field as hidden to your report and filter it
there.

Brad

 

[Brad]

Format([YourDateFieldHere],"mm-yy")

Search Format Property or Format date in MS Access Help Answer Wizard and
look for Format Property - Date/Time Data Type.

Brad

 

[Douglas J. Steele]

Another alternative would be to use the following criteria:

BETWEEN DateSerial(Year(Date), Month(Date), 1) AND DateSerial(Year(Date),
Month(Date) + 1, 0)

 

[nancy]

Thank you for your help. I have converted the date to just a month

Then I created a form with a combo box listing the months of the year.

I have created a button where it will open up a report based on the month
chosen from the combo box

I have a query that pulls information from three tables. two of the table
has a place for a date to be entered. I have converted the date to the form
you gave me.


I created a macro that is supposed to select the information from the query
based on the selection from the combobox.

The where condition is [WlWD] Or [shd]=[Forms]![Form1]![Combo6]

It is pulling up all the information. Not just from the month selected.

Format([YourDateFieldHere],"mm-yy")

Search Format Property or Format date in MS Access Help Answer Wizard and
look for Format Property - Date/Time Data Type.

Brad

How do I format the field to show the month?