budget figure in actual field if blank

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
 
X

XPS350

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

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


Groeten,

Peter
http://access.xps350.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top