Find Range of Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to formulate a query that can pull out a range of numbers in one
column, say between 01-04, that have the same date in another column. A
sample of numbers that would go together looks something like this:

RAD Region
20050730 01
20050730 02
20050730 03

Thanks,
Sean Heckathorne
 
Hi Sean,

What do you mean "a range of numbers"? I woiuld have thought you could get
the numbers out with a query as simple as:
SELECT Region from Table1 WHERE RAD = [Enter Date]
 
David,
I have a file of shipments that are broken up into 14 regions. We are
trying to group together regions 01-03, 04-05, 06-10, etc. that have the same
RAD (receiving date). So on my example I didn't include the other regions
that are in the table, but only the ones that counted for that example. I
could use that select query but I want to return every date in the specified
range of regionswithout combining the other fields into one shipments. I
hope this is more clear? Thanks alot.
 
I have a file of shipments that are broken up into 14 regions. We are
trying to group together regions 01-03, 04-05, 06-10, etc. that have the same
RAD (receiving date). So on my example I didn't include the other regions
that are in the table, but only the ones that counted for that example. I
could use that select query but I want to return every date in the specified
range of regionswithout combining the other fields into one shipments. I
hope this is more clear? Thanks alot.
Click to expand...

Um, I'm afraid I still don't quite get it. What do you mean when you say you
are trying to "group together regions"? Does it mean that, for each RAD, you
want a comma separated list of all the regions? Or perhaps a crosstab list
where you can see which regions exist for each RAD? I guess I'm trying to
understand what the output is that you're after...
 
Back
Top