unique grouping records problem

  • Thread starter prairiewind via AccessMonster.com
  • Start date
P

prairiewind via AccessMonster.com

I'm not sure if this is a report or query issue, but will start here.

I supply a street level atlas for my agents. I have a database of where
clients live (map section and page; i.e. section 2, page 14). I would like
to group together all the clients that live on consecutive pages (page 13 &
14, then page 15 & 16, etc.) How do I go about this to get the desired
result?

Jeff
 
K

KARL DEWEY

Try this substituting your table name for Prairiewind --
SELECT Prairiewind.Sect, Prairiewind.Page, Prairiewind.Client
FROM Prairiewind
GROUP BY Prairiewind.Sect, Prairiewind.Page, Prairiewind.Client;
 
P

prairiewind via AccessMonster.com

One follow up. At present, the section and page number are in one field, but
could easily be separated if it would be easier and/or right to do. Present
format is: 2 - 14.

Jeff
 
K

KARL DEWEY

Based on your latest try this substituting your table name for Prairiewind --
SELECT Prairiewind.Sect-Page, Prairiewind.Client
FROM Prairiewind
GROUP BY Prairiewind.Sect-Page, Prairiewind.Client;

The section and page really does need to be in separate fields.
 
P

prairiewind via AccessMonster.com

Thanks for the reply. However, what I'm trying to do is group all of the
records that fall on page 1-2, 3-4, 5-6, etc. together, not just group the
individual pages together. Wonder if this is more of a report issue so will
do some searching along that line as well.

Jeff
 
P

prairiewind via AccessMonster.com

One follow up. One option would be to have a blank space after the last
record that falls under the odd page?

Jeff
 
P

prairiewind via AccessMonster.com

Just an example of what I'm looking for:
Section# Page#
1 1
1 1
1 2

1 3
1 4

2 5
2 6

2 8

and so on.
 
Top