Administrator: Receipts 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

The words may wrap to the second line on the page or in the Zoom box. There are NO paragraph or line breaks. Concatenate Try it: Combine the Fields. Select the LastName field on the QBE grid Go to Design->Query Setup Select Insert Column Zoom into the new, blank field Type the following:     Name: [LastName] & ", " & [FirstName]   Concatenate the City, State and Zip Insert a new column and type: CityStateZip: [City] & ", " & [State] & " " & [Zip]   Save the query as rptCustomerReceiptSQ. Query Tools ->Design -> Insert Column