Hello,

I have a table;

Start Date
End Date

And a query;

Start Date
Due Date
End Date
Timescale

Due Date works out Start Date + 7 days. Timescale is if End Date is bigger than the Due Date - i.e. a week old.

What I can't get to work though is criteria.

The timescale formula returns either Y or N and I want to make a query of all the Y's.

Can anyone help?

Many thanks.
Sk.

You probably have

Timescale: IIf([End date]>[due],"Y","N") and "Y" in the criteria, and get prompted for Due, this is because yoy cannot have a calculated field in the where clause. Change Timescale to IIf([End Date]>[Start Date]+7,"Y","N")

BTW spaces in names in Access are a pain in the neck as they mean Access cannot find them and you have to keep using [ ].

Brian