If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sorting a report with two tables
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. |
#2
|
|||
|
|||
sorting a report with two tables
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 -- Wayne Manchester, England. "Steve S" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|