Sort Orders

[Fran]

Hello, I'm a relatively novice user, so please excuse my ignorance. I have a
data base of photo competition entries. There is an entries table and a
members table. Both tables include a member ID linked many entries to one
ID. When I attempt to sort by last name in my reports, the report will only
print the first person of each last name (if there are two people with the
same last name it will print only the first and attribute all of the entries
for people with that last name to the first person). If I print, by
memberID, I will see all names and entries properly apportioned. No matter
what I do I cannot get the report to print alphabetically and include all
people with the same last name. Any ideas?

Second, the entries table also includes a month field. I have another table
with all the months in fiscal year order with corresponding monthID numbers.
My reports print in alpha order and I cannot get it to print in the fiscal
year order unless I include the monthID in my entry table, in which case the
report prints in proper order but lists numbers instead of month names. Any
help in solving this one will also be appreciated.

 

[Duane Hookom]

You can set up your sorting and grouping dialog to:
=LastName & FirstName & [MemberID] with group headers/footers
You don't have to display the field used for sorting and grouping within the
group header. You can display any field you want in a text box.

 

[Fran]

Hi, Duane, thanks for answering. I'm not sure I know how to do that, but I'll
give it a try and see if I can figure it out.
--
Fran

You can set up your sorting and grouping dialog to:
=LastName & FirstName & [MemberID] with group headers/footers
You don't have to display the field used for sorting and grouping within the
group header. You can display any field you want in a text box.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

Hello, I'm a relatively novice user, so please excuse my ignorance. I have a
data base of photo competition entries. There is an entries table and a
members table. Both tables include a member ID linked many entries to one
ID. When I attempt to sort by last name in my reports, the report will only
print the first person of each last name (if there are two people with the
same last name it will print only the first and attribute all of the entries
for people with that last name to the first person). If I print, by
memberID, I will see all names and entries properly apportioned. No matter
what I do I cannot get the report to print alphabetically and include all
people with the same last name. Any ideas?

Second, the entries table also includes a month field. I have another table
with all the months in fiscal year order with corresponding monthID numbers.
My reports print in alpha order and I cannot get it to print in the fiscal
year order unless I include the monthID in my entry table, in which case the
report prints in proper order but lists numbers instead of month names. Any
help in solving this one will also be appreciated.

 

[Fran]

Duane, it worked perfrectly! Thanks much. I will try the same with the
month problem.
--
Fran

You can set up your sorting and grouping dialog to:
=LastName & FirstName & [MemberID] with group headers/footers
You don't have to display the field used for sorting and grouping within the
group header. You can display any field you want in a text box.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

Hello, I'm a relatively novice user, so please excuse my ignorance. I have a
data base of photo competition entries. There is an entries table and a
members table. Both tables include a member ID linked many entries to one
ID. When I attempt to sort by last name in my reports, the report will only
print the first person of each last name (if there are two people with the
same last name it will print only the first and attribute all of the entries
for people with that last name to the first person). If I print, by
memberID, I will see all names and entries properly apportioned. No matter
what I do I cannot get the report to print alphabetically and include all
people with the same last name. Any ideas?

Second, the entries table also includes a month field. I have another table
with all the months in fiscal year order with corresponding monthID numbers.
My reports print in alpha order and I cannot get it to print in the fiscal
year order unless I include the monthID in my entry table, in which case the
report prints in proper order but lists numbers instead of month names. Any
help in solving this one will also be appreciated.