Customized Grouping in MS Access 2003 Reports

I am attempting to group records in an MS Access 2003 report by using a field
in the table that is different from the one entered into each record. In
other words, the groupings available to me are alphabetical or numeric only,
but I want to create my own "custom" sort by using the key code for that
underlying table, which is numerical, and in the sequence I want .

Each record contains a "Status" field ... these are "National", "Regional",
"Provisional", "or "None", but Access won't display them in that sequence,
since then they wouldn't be alphabetical. The table where the "Statuses" are
stored has two fields: "Key" and "Status". I want to group the records in
my report by the Key, not the Status. Is this possible?

I know I can artificially place a numeral at the beginning of each "Status"
(e.g., "01National", "02 Regional" ...), but I'd rather not.

Make sure the "Key" field is in the report's record source so you can
sort/group by it.

--
Duane Hookom
Microsoft Access MVP


"Lawnchair Bill" wrote:

I am attempting to group records in an MS Access 2003 report by using a field
in the table that is different from the one entered into each record. In
other words, the groupings available to me are alphabetical or numeric only,
but I want to create my own "custom" sort by using the key code for that
underlying table, which is numerical, and in the sequence I want .

Each record contains a "Status" field ... these are "National", "Regional",
"Provisional", "or "None", but Access won't display them in that sequence,
since then they wouldn't be alphabetical. The table where the "Statuses" are
stored has two fields: "Key" and "Status". I want to group the records in
my report by the Key, not the Status. Is this possible?

I know I can artificially place a numeral at the beginning of each "Status"
(e.g., "01National", "02 Regional" ...), but I'd rather not.