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
Click to expand...

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

Similar Threads

How to default CurUser() into a field in a new record in a Select 5
your 2 cents on this form design 3
Find Total and insert one blank row below 4
Challlenging COUNT IFS? 5
AutoNumber correlate with Number? 3
Update existing values incrementally w/UPDATE SQL 12
SQL string in VBA 4
Add record then lock field 5

Top