I have a report which is based upon a series of user selections in a form, the last of which is a listbox containing dates. I have a RUN REPORT button which takes all criteria into account (builds up a WHERE string) and then uses docmd.OpenReport and the WHERE string to display the report with the appropriate records.
The problem I'm having is that any time a date or dates are selected, the report returns nothing, despite there being records that match the criteria. After stepping through the VBA, the WHERE condition for the dates is something like this : "qryPerformance.dtmPerf = #15/04/03#" which to me looks correct.
Does anyone have any ideas what I can do to resolve this? I've tried various different syntaxes but the one above seemed to be accepted ok.
Thanks a lot.
Graham
The problem I'm having is that any time a date or dates are selected, the report returns nothing, despite there being records that match the criteria. After stepping through the VBA, the WHERE condition for the dates is something like this : "qryPerformance.dtmPerf = #15/04/03#" which to me looks correct.
Does anyone have any ideas what I can do to resolve this? I've tried various different syntaxes but the one above seemed to be accepted ok.
Thanks a lot.
Graham