query Criteria

[Cathy]

I have a query where it works out if reports are late being recieved and how
many working days late they are. in the report due column the criteria is
<Now() and then there is a column that works out how many working days late
the report is. However i wanted to do another query to work out how many
were late over 60/90 days. I have tried to put >=60 in the working days
column but i get an error message.
Can anyone help? Many thanks

 

[ldiaz]

Maybe you can use

Date()-60

Thanks

 

[Cathy]

thanks thats great.

However is there anyway i can work it out with working days, taking out the
weekends? thanks

 

[Pieter Wijnen]

< Date() -60 And < Date() -90

Pieter