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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by shangus

  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