I have a MS 2003 Dbase with some of the fields following:
House_no, Address1, Address2, Lname,Fname, etc..etc..etc...
Sample data is:
10, Avery Street, , Smith, Tom
10, Avery Street, , Smith, Amy
12, Avery Street, , Jones, Bob
12, Avery Street, , Jones, Mary
I would like to generate a Label report that would look like this:
Tom & Amy Smith
10 Avery Street
Bob & Mary Jones
12 Avery Street
I tried a query where I concatenated House_No, address1, and Lname to create a unique Identifier But I am now lost. Any help you can toss my way would be greatly aprpeciated.