Parameter using Month Number

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

Guest

I have a column in a query that is ship date. I want to find all of these
for one month. How can I just query the user to enter the month number.
 
Nikki said:
I have a column in a query that is ship date. I want to find all of these
for one month. How can I just query the user to enter the month number.
Click to expand...

Create a computed column in the query:

MonthNo: Month([MyDate])

(replace MyDate with the name of your date field, of course)

then for the criteria in that column:

[Enter Month Number]

That won't test for years, though.

Tom Lake
 
Is there a way to query for the year using only one parameter box?
--
Thanks,
Nikki


Tom Lake said:
Nikki said:
I have a column in a query that is ship date. I want to find all of these
for one month. How can I just query the user to enter the month number.
Click to expand...

Create a computed column in the query:

MonthNo: Month([MyDate])

(replace MyDate with the name of your date field, of course)

then for the criteria in that column:

[Enter Month Number]

That won't test for years, though.

Tom Lake
Click to expand...
 
Do the same thing as Tom suggested for Month only use
Year([MyDate])

--
Duane Hookom
MS Access MVP


Nikki said:
Is there a way to query for the year using only one parameter box?
--
Thanks,
Nikki


Tom Lake said:
Nikki said:
I have a column in a query that is ship date. I want to find all of
these
for one month. How can I just query the user to enter the month
number.
Click to expand...

Create a computed column in the query:

MonthNo: Month([MyDate])

(replace MyDate with the name of your date field, of course)

then for the criteria in that column:

[Enter Month Number]

That won't test for years, though.

Tom Lake
Click to expand...
Click to expand...
 
Back
Top