Is this possible

[Rocky Frazier]

Hi, I have a mdb with a field on a form called "Month"...it contains a text
value of January...or February.....or March...ect....

I want a query to ask what ....and the answer should be ONLY the inputted
info...for instance in the Criteria field of Month <which contains only the
Month's name...ie ..January...ect....

I want to run a query that only brings up all the records with January as
the [Month]= "January"....how do I do this?

Thanks,
Rocky

 

[Dorian]

You can run a query against a table, not a form.
If the months are in a table then you can do it by
creating a query "SELECT * FROM MonthsTable WHERE Month =
[Forms]![Formname]![MonthControlname]"
Or maybe I did not understand your question.

-----Original Message-----
Hi, I have a mdb with a field on a form

called "Month"...it contains a text

value of January...or February.....or March...ect....

I want a query to ask what ....and the answer should be ONLY the inputted
info...for instance in the Criteria field of Month <which contains only the
Month's name...ie ..January...ect....

I want to run a query that only brings up all the records with January as
the [Month]= "January"....how do I do this?

Thanks,
Rocky

--
James R. Frazier
(e-mail address removed)
http://remotecare.vstoreoffice.com
"Never Bite off More than your Donkey can Carry"


.