Do a union with a control source

M

martin

I have a query that is used 14 times as a recordsource for
14 subforms. The query is changed programatically 1 day
greater in each of the subforms. I am now testing with
about 200 records and it is slow. Is there a way to add 1
day to the previous query without doing the whole query
again. I was thinking union query might do this?

Thanks
Martin
 
Top