sorting a report with two tables

[Steve S]

Hi there,
I have an access 2003 club membership database with a "membership table"
(with personal data) linked to a "roles held table" that describes the work
done by members over the years. The key between tables is named "memberid".
When I create a report i need to sort it by "lastname" then "firstname".
Then the roles are to be sorted by "year".

The report tables are linked and therefore grouped by "memberid" and this
forces the sort in that order rather than by last name firstname.

How can I create this report to sort correctly please.

Many thanks in advance.

 

[Wayne-I-M]

Hi Steve

Don't base your report on the tables. Create a query based on the tables
then base your report on that. - As long as all the fields in the report are
in the query yu will not need to redesign your report - other than the source
row.

Use the sorting and grouping options in the report.
Looking at what you have put I think (but may be wrong about this) that you
may want to sort the report by Year (there is an option form the in the
Options Box). Make sure you put a header on this group and just include the
Year in this to make it simple to usederstand for anyone reading it.
Then sort by Surname and then by 1st name

Basically you should "play around" wth the sorting and grouping box to see
what result you are happy with.

HTH