If Exits in this table use this, if not use that one?

[JazzSP8]

Hey All

I'm treading water in Access again :-/

I'm pulling together some data from various locations, one price field in has two different versions, a "now" and a "future" both held in different Tables.

I want to be able to edit my Query so that; "If the price exists in the Future, use the Future price, otherwise use the Now price"

I found IIF but I don't think I can use that?

Any help / suggestions gratefully received.

Thanks

 

[Norie]

Can you join the 2 tables?

If you can then you should be able to set up an appropriate expression to pull the required price.

=Nz([Table2]![FuturePrice], [Table1]![NowPrice])

 

[JazzSP8]

Aha! - Yes, I can do that, I saw Nz earlier when I was Googling.

Thanking you for that push in the right direction Mr. Norie Sir!