Confused !

[Richard G]

I have written the following query for use with my Automatic Weather Station

10 Min Wind Direction: Val(IIf((([Date]="11/07/2006") And ([Time text]>=1600) Or ([Date]>"11/07/2006")),[CR10X AWS]![Field6],""))

Basically I had some data from 1300hrs on 7th July until 1600hrs 11 July that was wrong and I needed to 'null' the data reading - the above works fine showing a value of '0' for the incorrect data between these times / dates and all the correct values are displayed since then however, since 01 August the field nows shows 0 again - any ideas why ?

Regards

Richard

 

[elbweb]

try using pound/sharp signs around the dates/times instead of quotes.

this tells the program that the data within them is a DateTime instead of a litteral string.

i.e. use #11/07/2006# instead of "11/07/2006"