Data type mismatch in criterial expression

[rajeevwgs]

Hi Everybody,
I am trying to prepare one ageing report, and its almost completed but i cannot make sum() in query as well as report because its coming "Data type mismatch in criterial expression", I tried several times but fed up with this, help me please in this issue.
1. In table i made amount column as number
2. this is what i used in my query

First: IIf(DateDiff("d",[refdate],Now()) Between 1 And 15,[amount],"")
when i put sum() the data type mismatch is coming

3. also in report when i tried to put group,Sort total then also i cannot make sum(first)

Please help me in this issue...:banghead:

 

[recyan]

Till someone comes along,
1) Have you tried
First: IIf(DateDiff("d",[refdate],Now()) Between 1 And 15,[amount],0)
2) Not sure, but, think, we should avoid using "First", try using TheFirst.

Thanks

 

[rajeevwgs]

Till someone comes along,
1) Have you tried
First: IIf(DateDiff("d",[refdate],Now()) Between 1 And 15,[amount],0)
2) Not sure, but, think, we should avoid using "First", try using TheFirst.

Thanks

Thanks...It is working...I was thinking since 2 days for a solution...