Query Criteria

[nicola1]

Hi all,

In my query i have 5 different fields showing different type of fuel types, these are checkboxes on a form.

I have another field which shows the 'dry time' (this is calculated on two other fields, the time of runout and time of delivery)

What i want to to is have a selection criteria whereby if 'Diesel' (one of the fuel tyeps) dry time is over 06:00 hours, it is displayed.

Im not sure whether this should be in the Diesel field, or the dry time field.

I have tried both using:

'Diesel' > "06:00" and also 'Dry Time' > "06:00"

but niether work...any help would be appreciated. Thanx

 

[neileg]

If I understand you correctly you need two criteria, one for the diesel checkbox being true and second for the drytime over 6 hours.

 

[nicola1]

Thanks so much! im so dozy! How did i not know that