Search results

Yup, that was it, when I removed all the columns that had unique data in them to leave the address only I forgot to take out the "ALL" from the SQL. Thanks to Galaxiom and the_net_2.0 I really appreciate your help with this one. A minute conversation with you had a better effect than 3 hours...

I just took out everything from the union query that had different values (basically everything except the addresses) to see how it would deal with a data set that had identical entries and it was still showing multiple adresses

Hi, yes, I'm using UNION ALL, I removed the " ALL" and it didn't seem to make much difference. I should have mentioned that any rows that have the duplicate addresses will have unique values in other fields

I probably should have mentioned that I've got the union query in there as a way of extracting the most recent set of data from the whole database. It unifies the remainder of the day (i.e. everything since the last set of labels was printed) with whole days (since the last labels were printed)...

I've got a nice little database that uses a union query to give me a sheet of address labels, sometimes people buy more than one thing and at the moment I'm wasting paper printing off multiple address labels that are the same. I don't want to mess around with the base data as I use that for...