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
|
|||
|
|||
Label Report
I have a situation where I need to create labels from a table. The table is
ClassEntries. Fields include: BackNumber ClassNumber RiderName Sample Data: Back# Class# Rider 1 2 Brianna White 9 2 Kira Kaseloo 12 2 Jennifer Batts 23 2 Claudia Coombs 24 2 Christina Boucher 29 2 Kennedy Seeley 39 2 Lillian Moore Back# Class# Rider 1 3 Brianna White 9 3 Kira Kaseloo 17 3 Morgan Hodge 28 3 Kennedy Seeley 29 3 Morgan Palmer 34 3 Josh Monahan 41 3 Kate McGregor I can query the data, sort by BackNumber and ClassNumber. When I go to do labels, it creates 1 label per BackNumber/ClassNumber. Somehow, I need to create labels that have the BackNumber with ALL of the classes entered on one line instead of individual labels. Instead of Back# 1 Class# 2 Rider Brianna White I need: Back# 1 Class# 2,3 Rider Brianna White I am beside myself trying to figure this out! Thanks for any assistance. DN -- DN |
#2
|
|||
|
|||
Label Report
DNuding wrote:
I have a situation where I need to create labels from a table. The table is ClassEntries. Fields include: BackNumber ClassNumber RiderName Sample Data: Back# Class# Rider 1 2 Brianna White 9 2 Kira Kaseloo 12 2 Jennifer Batts 23 2 Claudia Coombs 24 2 Christina Boucher 29 2 Kennedy Seeley 39 2 Lillian Moore Back# Class# Rider 1 3 Brianna White 9 3 Kira Kaseloo 17 3 Morgan Hodge 28 3 Kennedy Seeley 29 3 Morgan Palmer 34 3 Josh Monahan 41 3 Kate McGregor I can query the data, sort by BackNumber and ClassNumber. When I go to do labels, it creates 1 label per BackNumber/ClassNumber. Somehow, I need to create labels that have the BackNumber with ALL of the classes entered on one line instead of individual labels. Instead of Back# 1 Class# 2 Rider Brianna White I need: Back# 1 Class# 2,3 Rider Brianna White I am beside myself trying to figure this out! Thanks for any assistance. DN use some version of fConcatChild to aggregate all the Class numbers into a delimited string and then use the query that calls fConcatChild as the source for your report. See www.mvps.org/access in the modules section for fConcatChild -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|