My problem is that i have a query which displays a series of totals for a nominated period of time, based on date parameters entered by the user. This works fine. I also have a query that does exactly the same thing, returns a series of totals, but without the date parameters.
What i am trying to achieve is a report that will display both sets of results. I have tried a Union query, but both queries must have the same amount of fields (mine don't as the query with the date parameter has more). Hope someone can help.
What i am trying to achieve is a report that will display both sets of results. I have tried a Union query, but both queries must have the same amount of fields (mine don't as the query with the date parameter has more). Hope someone can help.
