Report - Sort by related index, replace with values from other tab

[BlueWolverine]

Hello

I am using MS Access 2003 on XP Pro.

I have a reports with 13 subsections, i.e. using the wizard, I broke it out
by this one field, call it CAT, such that all the records are grouped by CAT.

The problem is, the CAT has two pieces of related information, determined by
a different table, call it CATKEY.

CATKEY contains 3 fields: CATorder, CAT, and CATName

The data stored in the table the report pulls from is CAT, and I want the
report to Display CATName instead of CAT, and I want them to sort in
ascending order of CATorder. I also want this to be fast. In excel this
would be pretty simple, I think. I don't know how to do it in access.

Here's my guess for the approach. Update query to replace CAT with CATName
in the main table. This solves problem A.

Then, I have no idea.

Note: I would rather NOT replace CAT with CATName in the main table.


Thank you,

 

[John Spencer]

Add the CatKey table to the query for the report and join Catkey.Cat to
YourTable.Cat. Then you can use the fields in the CatKey table.

If you don't know how to make a query or to join two tables together then post
back for further directions.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County