joining queries!! how!
From: manish (anonymous_at_discussions.microsoft.com)
Date: 06/18/04
- Next message: anonymous_at_discussions.microsoft.com: "Is there a way to do this ?"
- Previous message: Paul Digby: "Re: LEFT JOIN"
- Next in thread: Gary Walter: "Re: joining queries!! how!"
- Reply: Gary Walter: "Re: joining queries!! how!"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 18 Jun 2004 03:53:59 -0700
I have two cross tab queries in the following format :
both the queries have the following format
Account may june july aug
------- ------ ------ ------ ------
Account contains the infomation like : courier, salary,
purchases etc... the month columns show the monthly
expenses of each account.
One query is for cash expenses.
The other is for bank payments.
both the queries are based on other queries.
Till here there is no problem.
Now i want to merge the two queries into one so that i can
have one column for "cash-may" and one column for "bank-
may" similarly there should be columns like :
cash-june bank-june cash-july bank-july
--------- --------- --------- ---------
is this possible???
if not how can i merge & sum the data from two queries.
I need to make a report at the end of every month to show
the cash expenses, the bank payments and the total of it.
How do I???
any suggestions will be highly appreciated.
warm regards
manish
- Next message: anonymous_at_discussions.microsoft.com: "Is there a way to do this ?"
- Previous message: Paul Digby: "Re: LEFT JOIN"
- Next in thread: Gary Walter: "Re: joining queries!! how!"
- Reply: Gary Walter: "Re: joining queries!! how!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
