D
denton
I cannot create join queries to save my life and it's crippled my ability to
get my data. For example, I have two tables: Trades and Equity
---Trades:
AccountNumber
Salesman
Commission
Date
----Equity
AccountNumber
Salesman
Date
Balance
The Trades table could have 100s of trades in an account in a day.
The Equity table has a balance for each account by day.
I want a query which has every transaction, but also gets the balance for
each account on that day. What relationships need to be created?
Everything I try creates duplicate records. Any good resources you know of?
get my data. For example, I have two tables: Trades and Equity
---Trades:
AccountNumber
Salesman
Commission
Date
----Equity
AccountNumber
Salesman
Date
Balance
The Trades table could have 100s of trades in an account in a day.
The Equity table has a balance for each account by day.
I want a query which has every transaction, but also gets the balance for
each account on that day. What relationships need to be created?
Everything I try creates duplicate records. Any good resources you know of?