Report - Sub Values from indexing table into report

[BlueWolverine]

Hello
This is a bit of a repost. As I clicked post the first time, I realized I
saved this to queries when I think I should have sent it to Reports. My
apologies.

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.

 

[Matt Wickham]

Your Report -> Record Source will need to be changed to a query. You can use
Query Builder to include both the CAT table and the CATKEY table in a join on
CAT field. Query Builder is easier, but it should generate a SQL View
something like, "select CAT.*, CATKEY.* from CAT, CATKEY where CAT.CAT =
CATKEY.CAT. Once you join the two tables, you can use any of the CATKEY
fields to report and sort on.