Access: Screen Play Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Concatenate the Fields Try it: Add the following concatenation: Select the second column in the grid and type: CustomerPhone: [Phone] & " " & [LastName] & ", " & [FirstName]   Save the Query and name it: CustomerPhoneSQ Memo to self: Code is typed as one long string of characters. Sometimes the Text Wrap in the Zoom box, or even in this Guide, makes it look like there are line breaks.