Can a query be run on separate tables in RS

[DCount]

I have a very complex query that needs to return monthly and year-to-date data. I'm using one table (table A) to correctly return the monthly data. I would now like to create another table and use a result from table A to correctly filter and display the year-to-date data along side the monthly data.

Does RS allow querying between tables?

Thanks

 

[hmckillop]

Not sure what you mean?
The RS (recordset) contains whatever you put in it, so if you want both tables, where they match you can do stuff like
set rs = myConn.Execute "SELECT * from MyTableA inner join MyTableB on MyTablea.id = MyTableB.id"

this joins both tables, alternatively you can use the union statement
set rs = myConn.Execute "SELECT * from MyTableA UNION ALL SELECT * FROM MyTableB" --on the provision column number and types match.



"I'm living so far beyond my income that we may almost be said to be living apart