Does RS allow querying between tables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DCount17 - 31 Mar 2005 15:49 GMT

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?

Example of desired results
Account July 2004 Year-to-Date
Ace Hardware $3000.00 $8452.21

Signature

DCount

Reply to this Message

Timm - 31 Mar 2005 16:07 GMT

You can't really use table A to display results into a different table. But
what you may want to try is to use the same dataset used in table A to create
a new table B and then on table B goto the properties of the table and then
goto the filters entry there and apply the filters you want to the table.
That should get you the results you're looking for.

> 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
[quoted text clipped - 7 lines]
> Account July 2004 Year-to-Date
> Ace Hardware $3000.00 $8452.21

Reply to this Message