F
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.
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.