How do I put in date criteria to search for birthdays within a pa.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a novice. Please help. What wildcard is used for the year in a date
field? I am trying to query for birthdays in a particular month for the
employees.

Thanks
 
Add a new column to the query like...
BirthM: Format([BirthDateField],"mm")

in the criteria put...
= [Enter Month in the format MM]



Hope that helps!


Rick B
 
Presumably you are constructing filter clauses to pass to the report? If so
then if user has not seleceted in combo and combo has no default value its
value will be Null. So when constructing your filter clause you can do
something like...

If not IsNull(combo_field) then
filter_string = "column_name = " & combo_field
else
filter_string = ""
end if

Madhouse



Rick B said:
Add a new column to the query like...
BirthM: Format([BirthDateField],"mm")

in the criteria put...
= [Enter Month in the format MM]



Hope that helps!


Rick B



BB said:
I am a novice. Please help. What wildcard is used for the year in a date
field? I am trying to query for birthdays in a particular month for the
employees.

Thanks
Click to expand...
Click to expand...
 
Back
Top