pulling through multiple query data into a report

[Triacona]

Hi,
I have a report which uses the query DateDec, this query uses the following criteria: It uses the field: DATEDECISS (decision date) which pulls data from a form ChooseDates. (Period starting from to end of period).
So if I try and count the Applications validated during the specified time period, it only counts the ones that are valid and have a decision date.
So now my question is how do I pull through in the report data from another query (DateAppVal)?
this is the formula I use in the report:

=Count(IIf(DateAppVal!DATEAPVAL between Forms!ChooseDates.StartDate And Forms!ChooseDates.EndDate,0))

It then asks me for a parameter value (so it is not using the dates provided) if I put a date in the value is 0 and if I put no input and just press enter in the value is 0.
The number the query (DateApVal)generates is 129, this is the number needed...
Is my formula incorrect?
Any help would be really greatly appreciated
Kind regards
Triacona

 

[randy700]

If I'm not mistaken, you're missing the ELSE portion of your IF statement.

Randy

 

[Triacona]

Hi Randy,

Thank you for your help.
I have managed to get it working via a sub-report using information from the DateApVal query and using =count([REFVAL]) in that subreport to give me the numbers I needed.
Thanks again
kind regards
Triacona