I have 4 tables with like data from different facilities.
I need to pull each like field for that month from each table and get a grand total to put in a report.
I have a report that was made from a union query and then put into a crosstab. I follow the tip FAQ but my problem is each month has different # of days. At the far right hand end I will end up with Totals for each row. I'm using D30-D0 as the dates. Here is the SQL Statement:
PARAMETERS...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.