Access Query Formula

[jacobsen]

Can anyone help me please.

I currently have a query that is trying to calculate the difference between two records in two other queries. The formula I am using is:

Conns: Sum([Grwthnew - Daily Summary]![Conns]-nz([Libra Input - Daily Step2]![Conns],0))

This works where the records match or where there is a record in the Libra Input - Daily Step2 query table but if it is in the first query table Grwthnew - Daily Summary noting is returned.

Is there a formula to say if the record is in the first query table but not in the second then make the second zero so it subtracts zero from the first number.

Thanks for any help.
Mark

 

[buckeye_td]

Do you have a Left Join from ([Grwthnew - Daily Summary] to [Libra Input - Daily Step2]? This will return all of your ([Grwthnew - Daily Summary] records even if there is not a match in the other source.

TD