Query with multiple and clauses

[Abena]

Hi,



I need immediate assistance updating a field in an Access table based on a specific criteria. For example: [t1]![tdt]>=[t1]![cdt] and<[t1]![f2dt] and[t1]![f1dt] and [t1]![Ddt]. Tdt field should be greater than or equal to cdt field but also less than all the other fields mentioned above. Thank you.

[JoeM]

You have practically already written it.
You can use multiple Criteria under a field. Just combine them all with the word "AND" between each check.
Note that each condition needs to be a complete expression. You cannot say "a is less than b and c". You need to say "a is less than b and a is less than c".

If you run into any trouble, change your query to SQL View and copy and paste your query code here so we can help you modify it.

[davegri]

As JoeM stated:
The structure is like this

[t1]![tdt] >= [t1]![cdt] 
and
[t1]![tdt] < [t1]![f2dt] 
and
[t1]![tdt] < [t1]![f1dt] 
and 
[t1]![tdt] < [t1]![Ddt]