G
Guest
Hi. I am working on a query that is pulling from 2 tables. Its WHERE
Statement includes all items where cash in or cash out falls in the following
cases:
1. one large transaction for a single day that is between 3,000 and 9,999
2. multiple smaller transactions in a single day that is between 3,000 and
9,999
Here is what I have so far:
SELECT Day1.ACCOUNT_NUM, [Account Info].NAME, Day1.[CASH-IN],
Day1.[CASH-OUT], Day1.DATE, [Account Info].[Branch Number]
FROM [Account Info] INNER JOIN Day1 ON [Account Info].Account_Num =
Day1.ACCOUNT_NUM
WHERE (((Day1.[CASH-IN]) IS NOT NULL) OR ((Day1.[CASH-OUT]) IS NOT NULL));
Can anyone help me with the rest of the WHERE statement?
Statement includes all items where cash in or cash out falls in the following
cases:
1. one large transaction for a single day that is between 3,000 and 9,999
2. multiple smaller transactions in a single day that is between 3,000 and
9,999
Here is what I have so far:
SELECT Day1.ACCOUNT_NUM, [Account Info].NAME, Day1.[CASH-IN],
Day1.[CASH-OUT], Day1.DATE, [Account Info].[Branch Number]
FROM [Account Info] INNER JOIN Day1 ON [Account Info].Account_Num =
Day1.ACCOUNT_NUM
WHERE (((Day1.[CASH-IN]) IS NOT NULL) OR ((Day1.[CASH-OUT]) IS NOT NULL));
Can anyone help me with the rest of the WHERE statement?