Query for a specific month, many years

[Guest]

I left a post yesterday but I wasn't clear and got a wrong answer, although
it was useful information. I'm going to try again.

I want to make a query that I can use in a report to show every September
for the last 10 years. The date in my table is formatted as m/yyyy. I work
for a school and my goal is to show enrollment trends for the last 10
Septembers. I know how to query for a range of dates, I just can't figure
out how to only pull September out.
Thanks for all the help you all give. Us "Dummies" users couldn't do our
jobs without you!

By the way, does anyone know any good books that are good to keep at my desk
other than Dummies. I think I've outgrown that one?

 

[Guest]

Try using Month

Select * From TableName Where Month([DateFieldName]) = 9

 

[Guest]

Kelly,

If you ask a question and the answer(s) didn't solve your problem/question,
you should continue the thread (so the responder knows there is still a
problem) instead of starting a new thread.

When you start a new thread for the same problem, we have to search for the
previous Q/A to find out what the responses have been.

Sooooo, see your previous thread..

 

[Guest]

Thanks for the quick reply. I am almost there, but can you please give a
little more detailed instruction. Is this a new expression in a query, or I
am putting this somewhere else? I am really new to this and am learning as I
go. (I tried this as a new expression and it's not working.)

Try using Month

Select * From TableName Where Month([DateFieldName]) = 9

--
\\// Live Long and Prosper \\//
BS"D

I left a post yesterday but I wasn't clear and got a wrong answer, although
it was useful information. I'm going to try again.

I want to make a query that I can use in a report to show every September
for the last 10 years. The date in my table is formatted as m/yyyy. I work
for a school and my goal is to show enrollment trends for the last 10
Septembers. I know how to query for a range of dates, I just can't figure
out how to only pull September out.
Thanks for all the help you all give. Us "Dummies" users couldn't do our
jobs without you!

By the way, does anyone know any good books that are good to keep at my desk
other than Dummies. I think I've outgrown that one?

 

[Guest]

Can you post the SQL you have, with the date field name?

--
\\// Live Long and Prosper \\//
BS"D

Thanks for the quick reply. I am almost there, but can you please give a
little more detailed instruction. Is this a new expression in a query, or I
am putting this somewhere else? I am really new to this and am learning as I
go. (I tried this as a new expression and it's not working.)

Try using Month

Select * From TableName Where Month([DateFieldName]) = 9

--
\\// Live Long and Prosper \\//
BS"D

I left a post yesterday but I wasn't clear and got a wrong answer, although
it was useful information. I'm going to try again.

I want to make a query that I can use in a report to show every September
for the last 10 years. The date in my table is formatted as m/yyyy. I work
for a school and my goal is to show enrollment trends for the last 10
Septembers. I know how to query for a range of dates, I just can't figure
out how to only pull September out.
Thanks for all the help you all give. Us "Dummies" users couldn't do our
jobs without you!

By the way, does anyone know any good books that are good to keep at my desk
other than Dummies. I think I've outgrown that one?