Sorting Data into Groups

[Guest]

I hope this is the right group --- My problem is this ---- I need to take the
information in a table and div it into 3 groups and then I need to sort those
groups into 3 as subgroups.
I really am at a loss and the boss wants it yesterday.
Thank You
For any help

 

[Duane Hookom]

This looks like the same exact question you started a thread in
access.reports news group. Please limit your posts to a single news group.

 

[John Spencer]

What do you have that you can use to divide the data?
How accurate do this have to be?

If you have an autonumber field or a primary key field that is unique
numbers, then one method would be

SELECT *, NumberField Mod 3 as GroupNumber
FROM SomeTable
Order By NumberField Mod 3, NumberField.

If you need to just get one group at a time, then add a where clause against
group number specifying 0, 1, or 2.

Again, it depends on what the structure of your table is.