works for one date but not others

[pwicr]

When the report generates using March 2 the reports (letter and labels) work.

When I try to generate the reports for today, March 5, using the same parameter form, I get nothing. and yet there are 34 entries to print.

Weird???

Please help.

 

[spikepl]

If you are not US-based, then you probably messed up the dates, that have to be mmddyyyy when talking SQL. If you are US-based, then you haven't provided enough clues.

 

[Kiwiman]

Howzit

What is the SQL underlying the report? It may be just the date format that is causing the problem. You may think you are querying March 5 (5/3/2012), but Access may be interpreting it as May 3 (3/5/2012).

Edit: Sorry Spike didn't see your post

 

[pwicr]

If you are not US-based, then you probably messed up the dates, that have to be mmddyyyy when talking SQL. If you are US-based, then you haven't provided enough clues.

The information is pulling from the same form (same table) and both days reports were pulled from the same parameter form using the date picker. Both the field in the form and the field in the parameter form are "short date". Both the main entry form and the parameter form use the date picker.

Where, deep down, can I check?

 

[pwicr]

SOLVED!

when default value is set to =now() it puts the time in there as well so it won't show up in parameter filters. Once i took out the default value of now() and re-entered the dates so there was no time, it worked like it was supposed to.