Query - Start Date End Date For Report (1 Viewer)

[Shaunk23]

I have a profit summary im running in a report. There is a form where the user enters in 3 combo boxes the information for report IE: Job Manager, Quote Status Etc.
There is then two text boxes - CQStartDate & CQEndDate

In the report record source i have selected the "date created" from the table & in the criteria i am trying to get "between Start date & end date" but i cant get it to work... I have tried

>=Forms![SysCon_CQdata]![CQdatestart] And <=Forms![SysCon_CQdata]![CQdateend].

Also tried

Between Forms![SysCon_CQdata]![CQdatestart] AND Forms![SysCon_CQdata]![CQdateEND]


I get a " to complex to process " or it just wont open. once i remove this.. it works fine. Please help!

 

[thechazm]

I would try something like this

Between (#" & cdate(Forms![SysCon_CQdata]![CQdatestart]) & "# AND #" & cdate(Forms![SysCon_CQdata]![CQdateEND]) & "#)"

 

[raskew]

Hi -

This may simply be a typo, but in your explanation you list:

CQStartDate & CQEndDate

...but in your code it's:

![CQdatestart] and ![CQdateend]

Note it's CQStartDate vs. CQdatestart and CQEndDate vs. CQdateend.

Hope that may help - Bob