budget figure in actual field if blank

  • Thread starter Thread starter MikeF
  • Start date Start date
M

MikeF

Two tables, one is Budget the other Actual, sorted by RevID – a primary key
in both tables, feeding a query.

In qryNetRev …..
If the value for a record from Actual.NetRev is blank, would like that field
to return the value for that same record from Budget.NetRev.

This *has* to be a very normal practice, but can’t quite get the syntax
correct.

Any assistance will be much appreciated.

Thanx,
- Mike
 
Two tables, one is Budget the other Actual, sorted by RevID – a primarykey
in both tables, feeding a query.

In qryNetRev …..
If the value for a record from Actual.NetRev is blank, would like that field
to return the value for that same record from Budget.NetRev.

This *has* to be a very normal practice, but can’t quite get the syntax
correct.

Any assistance will be much appreciated.

Thanx,
-       Mike
Click to expand...

Add a field to the query.
YouNameIt: IIF(IsNull(Actual.NetRev);Budget.NetRev;Actual.NetRev)


Groeten,

Peter
http://access.xps350.com
 
Back
Top