I am looking for a way to set up a query that will fill a 'blank' field with a certain title based upon a date range.
Here's the details, I have a "Date Quoted" field. Based upon the age of that date each job is at a certain stage (i.e. week 1, week 2, etc.) At any given time I have about 500 jobs quoted, I would like a way to quickly identify what "week" each job is in. I'm guessing this would require some sort of if, then statement? but I have no idea how to do that. I need it to be able to say if the job is 1-7 days old, it's labeled week 1, if it's 8-14 days old - it's week 2, etc.