selective Next test Date ?

[Bob H]

have 1 main tools table with many different types in, and from that I have
1 query in which I have

NextTestDate: DateAdd('d',362,[LastTestDate]), which works well, but I hav
enow come across a situation where some tools require testing on a more
frequent basis than others.

Is it possible to have selective test dates in a query, like 1 for 362 days
then another for 90 days which is for Electrical equipment?

Thanks

 

[RonaldoOneNil]

Something like this

NextTestDate:
IIf([EquipType]="Electrical",DateAdd('d',90,[LastTestDate]),DateAdd('d',362,[LastTestDate]))