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!
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!