Report, with date range, is not displaying queries

[dcorning]

Hi,

I have a report, which depends on queries, in which you enter a start and and end date and it displays the query results.

Well the report works fine for most dates.

But if the dates are too close (such as within a month of each other) the whole report is blank, even though the queries still return perfectly fine numbers.

This worked fine in the past, but for some reason it doesn't anymore.

Any suggestions?
Thanks,
DC

 

[DCrake]

Could it be something to do with how the dates are being interpreted (UK or US)

 

[dcorning]

I doubt it.. because the date is selected with a drop down calendar


For example,

"From: 30-mar-10 To: 7-apr-10" Works,

but

"From: 30-mar-10 To: 6-apr-10" Doesn't work..

 

[dcorning]

Sorry, the pictures copied didn't work..

 

[DCrake]

How are you applying the criteria?

Between x And Y

or

>= X and <= Y

 

[dcorning]

Along the lines of:

>=([forms]![frm_status]![txt_start_date]) And <=([forms]![frm_status]![txt_end_date])

 

[dcorning]

DCrake,

I have found the source of my error.

I changed one query of the report, but forgot to take the Sum of the results.

Thanks for the extremely timely responses! Your questions helped get the ball rolling.

Cheers,
DC

 

[DCrake]

Glad to find that you sourced your error and that my input helped you.