Using Parameter Query w/ dates

  • Thread starter Thread starter FM
  • Start date Start date
F

FM

Hi!
I am fairly new to Access 2000. I have a table with a field
-"Initation Date" in Short Date format MM/DD/YYYY. I want to run a
report based on a parameter query where the user would only have to
specify the month and year of the initation date they want to see. Do
I need to construct a calculated field - if so, what would that look
like? Thanks in advance for any help!
 
Hi!
I am fairly new to Access 2000. I have a table with a field
-"Initation Date" in Short Date format MM/DD/YYYY. I want to run a
report based on a parameter query where the user would only have to
specify the month and year of the initation date they want to see. Do
I need to construct a calculated field - if so, what would that look
like? Thanks in advance for any help!
Click to expand...

Add a new column to the query:
NewColumn:Format([InitiationDate],"mm/yyyy")

As criteria for this column, write:
[Enter Month & Year mm/yyyy]
 
Back
Top