Date query criteria ?

[fibayne]

Hello again

I have a report based on a query with a calculated date field, is it possible to use the Between And criteria on this field (when I try it asks for parameters FDOM, perpass, perpasm, periodlu) on the report NPD is set to short date format

NPD: IIf([FDOW]<Date() And [perpass]>=0,DateAdd("m",([perpass]+1)*[periodlu],[FDOW]),IIf([FDOW]<Date() And [perpass]<0,DateAdd("m",([perpassm]+1)*[periodlu],[FDOW]),IIf([FDOW]>Date(),DateAdd("m",[periodlu],[FDOW]),IIf([FDOW]=Date() And [perpass]=0,DateAdd("m",[periodlu],[FDOW])))))

could anyone let me know if this is possible

thanks as always....Fi

 

[Brianwarnock]

You can not use Aliases in criteria, or Group by for what its worth.
You have to show the calculation each time with you horrible IIF I would consider whether another approach is possible.

Brian

 

[fibayne]

Hi Brian...thought that might be the case, unfortunately I dont have the Access knowledge to do the horrible IIf another way...you wouldnt happen to have a suggestion on how I could and then perhaps be able to set criteria on the date for the report ...cheers Fi