Hi thanks for all your replies they were very helpful. What about if I keep the tables but want to count the number of rows of one of the tables, is it easy to do? The thing is I tried that and kept getting a joined count. I need both tables for the report.
I have a report which is using two tables and I have been trying to use the command object to create a UNION query from the two tables but I always seem to end up with different recordset ie the total doesn't add up. What is odd is when I check the show sql query option I see the union sql...
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.