Create customizable ranges?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Good morning.

I am using Access 2003. I have a query that calculates the difference
between a clinic visit date to a sample collection date (Diff). I
would like to sort the "Diff" results into a variety of customizable
ranges (say 0-10, 11-20, 21-30, etc.) and then enter some sort of text
into a field at the end of the query.

I have done this in the past with IIF statements which work well but
the ranges need to be determined once and aren't flexible (the formula
needs to be manually altered). I am hoping it is possible to create a
simple table to house the range information and somehow link this
information to the query?

Is it possible to do this?

wdp

.

Relevant Pages

  • Re: DateDiff
    ... horizontal display, with all possible diff, aircraft as group ... Aircraft Event Date ... I need a query that provides the difference between each pair of dates ... Aircraft Datedif1 Datedif2 ...
    (microsoft.public.access.queries)
  • diff output
    ... i have two large text-files (output of a database ... query) and i have to do a diff on them. ... updates if there are new lines or deleted lines within a certain range. ... The output of the diff is much bigger then but this does not ...
    (comp.unix.shell)
  • Re: How do Diff?
    ... I was looking to diff at a folder level or the entire project tree for 2 ... I was able to query the differences based on the label and then generate a ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: how do i write if and else statement in access query
    ... > expression in access query with if and else statement to count the number of ... > day diff between date 1 and date 2. ... > display it as ‘0” value. ... > Do you have an idea how to write in the query? ...
    (microsoft.public.access.queries)