Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shangus

    Union query

    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.
  2. shangus

    Union query

    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...

Part and Inventory Search

Back
Top