Query Months "January to September" etc.

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I need a query to select a range of months. ie January to September. I have
a monthstbl with: [Month], [StartDate] and [Enddate] which represents pay
periods. This table has a relationship to [Employeehourstbl] I need to run
a query that will show me the number of hours worked, number of days worked
by a range of months (Sept. to Dec) etc. any ideas...Thanks...Randy
 
-----Original Message-----
I need a query to select a range of months. ie January to September. I have
a monthstbl with: [Month], [StartDate] and [Enddate] which represents pay
periods. This table has a relationship to
Click to expand...
[Employeehourstbl] I need to run
a query that will show me the number of hours worked, number of days worked
by a range of months (Sept. to Dec) etc. any
Click to expand...
ideas...Thanks...Randy

Try doing a critria in design view of (type it exactly
like this): Between[type beginning month]and[type ending
month]
 
I tried this With January to March. The result was January and March, but
it omitted February...Any other ideas;
Kristy said:
-----Original Message-----
I need a query to select a range of months. ie January to September. I have
a monthstbl with: [Month], [StartDate] and [Enddate] which represents pay
periods. This table has a relationship to
Click to expand...
[Employeehourstbl] I need to run
a query that will show me the number of hours worked, number of days worked
by a range of months (Sept. to Dec) etc. any
Click to expand...
ideas...Thanks...Randy

Try doing a critria in design view of (type it exactly
like this): Between[type beginning month]and[type ending
month]
Click to expand...
 
If you're actually using month names, remember that text doesn't know
anything about dates. Month names are going to sort in the following order:
April, August, December, February, March, May, January, July, June,
November, October, September.

You'll need to have an artificial month number field that you can use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Randy said:
I tried this With January to March. The result was January and March, but
it omitted February...Any other ideas;
Kristy said:
-----Original Message-----
I need a query to select a range of months. ie January to September. I have
a monthstbl with: [Month], [StartDate] and [Enddate] which represents pay
periods. This table has a relationship to
Click to expand...
[Employeehourstbl] I need to run
a query that will show me the number of hours worked, number of days worked
by a range of months (Sept. to Dec) etc. any
Click to expand...
ideas...Thanks...Randy

Try doing a critria in design view of (type it exactly
like this): Between[type beginning month]and[type ending
month]
Click to expand...
Click to expand...
 
Back
Top