I didn't use Access some time and now I'm struggling for couple of hours already with something that I used to know...
I need to pass the parameter (date) from a comboxes on a form to a query.
This is what I have in the query for particular date field:
Expand|Select|Wrap|Line Numbers
- IIf
- ([Forms]![frmOutput]![cboStartdate] Is Null
- Or [Forms]![frmOutput]![cboEnddate] Is Null;
- [tblConsensus].[ReportDate];
- [tblConsensus].[ReportDate] Between
- [Forms]![frmOutput]![cboStartdate] And
- [Forms]![frmOutput]![cboEndDate])
The problem is that nothing is shown after pressing RUN button, although the date range exists.
It seems to me that there is a problem with the format of the date, maybe it's not adding ## signs, I dunno...
Help!!
Thanks!