Hi All,
I need to make a query that will subtract the results from one query against the results of another, issue I have is that the results aren't equal....
Query1 (Last month cash ROB)
Cur Amount
EURO 500.00
USD 1000.00
GBP 50.00
Query2 (Cash used this month)
Cur Amount
EURO 100.00
Note I've only used euros this month and none of the other currencies
I need Query3 (Current Cash) to look like this:
Cur Amount
EURO 400.00
USD 1000.00
GBP 50.00
I tried to use an IIf statement in the query to say if currency from Query1 = Currency from Query2, query1.amount-query2.amount, query1.amount........but it is coming back with errors.....I think Query2 needs to have zero values for currencies that haven't been used....but not sure....some guidance on the right way to go about this would be amazing. FYI The currency is linked to a Currency Table so I can add more as needed
I need to make a query that will subtract the results from one query against the results of another, issue I have is that the results aren't equal....
Query1 (Last month cash ROB)
Cur Amount
EURO 500.00
USD 1000.00
GBP 50.00
Query2 (Cash used this month)
Cur Amount
EURO 100.00
Note I've only used euros this month and none of the other currencies
I need Query3 (Current Cash) to look like this:
Cur Amount
EURO 400.00
USD 1000.00
GBP 50.00
I tried to use an IIf statement in the query to say if currency from Query1 = Currency from Query2, query1.amount-query2.amount, query1.amount........but it is coming back with errors.....I think Query2 needs to have zero values for currencies that haven't been used....but not sure....some guidance on the right way to go about this would be amazing. FYI The currency is linked to a Currency Table so I can add more as needed