Union Query Report Code ?? Joseph 29.09.2006 18:31:01 I have a small business that I run, and I have used Service Time Management wizard to build my database, with some personal changes due to the personal preference and requirements. I am right now stumped at creating a report from a query that sends out notices, ie 1st, 2nd,... for payments. The problem is that I know that there is a way to have a "template" report for all the notices, just changing the data ( customer and which notice) but how?? I have made a union query that pulls the cutomer name and the correct notice that I specify only thru specific sql statement. But I have to make a seperate query for each notice for each customer ( sum(customers) x sum(notice)), makes for alot of queries. There has to be an easier way, but I can not figure it out. I can write basic code, and read it very well, so coding is not a problem for me. Is there a way to make this report possible?