Custom Query

[Paola]

I'm trying to customize a column response. I have the
following columns: date and hours
I'm trying to make sun: IIf([Date]=DateAdd("d",0,[date]),
[hours],0)
This would then make a "sun" column and give a response
of hours submitted on Sunday. With the following code,
I'm gettting all hours no matter what date.

Please assist.

Paola

 

[Duane Hookom]

If you add 0 days to any date, it should always equal its starting value.