Expression based off of date field?

[maacky99]

I have a field called "Date Quoted" in a query. What I would like to do is based upon the date in that field; have another field entitled "Status" automatically fill-in with an expression (i.e. Week 1).

Basically; based on how old the quote it I want it to be called Week 1, Week 2, etc. If the quote is 1-7 days old it would be week 1, etc

Any thoughts or ideas?

 

[FoFa]

Don't put this field in the table, usa a query and calculate it on the fly. Use DATEDIFF to calculate your week (look DATEDIFF up in help).