Concatenates multiple rows into one field

[ppoindexter]

i need to create a query that concatenates multiple rows based on another fields matching records

example:

record # fld_Book_Title
record 1: The Three Bears
record 2: The Three Bears
record 3: The Three Bears
record 4: Green Eggs and Ham

record # fld_Page_Numbers
record 1: 56
record 2: 101
record 3: 12
record 4: 42

Query Results

record #: Book: fld_Book_Title
record 1: The Three Bears
record 2: Green Eggs and Ham

record #: Pages: fld_Page_Numbers
record 1: 12, 56, 101
record 2: 42

thanks in advance

 

[ppoindexter]

Thank you, I just had stumbled on a post of yours from a while back to this very link...i thought i had searched the forum fairly well before i made my post but i guess i was in too big of a hurry.....thanks and sorry for troubling you with ONE more question of this nature

incidentally, the link was exactly what i needed.....

 

[ppoindexter]

i am having one problem
the field i am stringing is a list of page numbers
when i sort ascending i get a string such as:

108, 168, 35, 36, 62

i want it to read
35, 36, 62, 108, 168

i think i need to add a zero in front of the 2 digit numbers
is there a good way to do this?