Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unanswered: Fill a field based on criteria

    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.

    Any ideas????

    Thanks in advance for you input.

  2. #2
    Join Date
    Feb 2004
    Location
    Washington
    Posts
    49
    Try something like:

    Round((Now() - DateQuoted) /7)
    Cathy

  3. #3
    Join Date
    Feb 2004
    Posts
    4
    Thanks for your response, but I'm still getting familiar with Access, so when you say try something like...

    Where do I put that? In an update query? in the criteria field of the existing query?

    Also, would that or how would that fill a separate field in with a descriptive (from my example; week 1, week 2, etc.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •