Query Criteria

[sondriven]

I have a form that has a subform in it. Both based on queries and two seperate tables to store the appropriate data.

I want to create a report from this data. I started to put my query together and clicked the run button to test it and the query works great.

Then I added criteria for the date. I want to be able to print out a from/to date report.

I entered in the criteria and it asks me the dates and then it opens the query. But all the data is empty. I doubled checked the dates to make sure there was data for them and there is. Is there something wrong with the way this is set up?

I appreciate the help. Thank you.

John

 

[Jack Cowley]

You did not say what your 'code' looked like in your query but it should look something like this:

Between [Enter Begin Date] And [Enter End Date]

This should be in the criteria line of your date field...

hth,
Jack

 

[sondriven]

OH MY GOSH!

Its always something. I had the code right but I had the > and < backwards so it was defeating its purpose.
The Between Dates works, but I had a pop up form for the data entry.

Between [Forms]![Data Entry]![Begin Date] And [Forms]![Data Entry]![End Date]

THis works too. Thanks.