query by month

  • Thread starter Thread starter dave.degroot
  • Start date Start date
D

dave.degroot

Hi, in my query design view, I type in "Month(4)" for my date field in
order to get records that were recorded during April, and I know that
there are many that have been done in that month, however the query
returns no records... What am I doing wrong?
 
Create a new column in your query with the expression:
Mth: Month([YourDateField])
Then set the criteria under this column to
4
 
Hi, in my query design view, I type in "Month(4)" for my date field in
order to get records that were recorded during April, and I know that
there are many that have been done in that month, however the query
returns no records...
Click to expand...

You need to add a calculated column to the query:

Field: Mth: Month([date field])
Show: unchecked
Criteria: 4
 
[email protected] said:
Hi, in my query design view, I type in "Month(4)" for my date field in
order to get records that were recorded during April, and I know that
there are many that have been done in that month, however the query
returns no records...
Click to expand...

You need to add a calculated column to the query:

Field: Mth: Month([date field])
Show: unchecked
Criteria: 4
Click to expand...

Thanks guys, that helped out immensely. :)
 
Back
Top