Expression Builder Help

[3239]

I have a form the has Beginning date textbox, Ending date textbox, and Facility textbox.

The expression's for the Beginning date and Ending date text boxes work fine and produce results in my query. But when I try to build and expression for the Facility text box
my query produce no results.

What am I doing wrong?

Please help

 

[PHV]

What am I doing wrong?
Sorry, the crystal ball is in vacation.
If you don't post what you're doing, nobody can tell you what's wrong...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[3239]

Sorry if I didn't make myself clear. Now what I have is a Report Date Range Form that Opens A Report based on the date range entered. What I did was add an extra text box to the form and used the expression builder in a query to build and expression to display the report based on what I entered into the text box. Basically what I am asking is how do I get the form to display information on the report based on what I enter into the form.