Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please help: Creating formula based on database field value.

Status
Not open for further replies.
TimothyP

TimothyP

Programmer
Aug 6, 2002
135
US
What is the proper syntax to accomplish this?

If Table.FieldA is null
use Table.FieldB
else
use Table.FieldA.

Thanks in advance for your assistance.
 
Sort by date Sort by votes
If IsNull({TableA.Field})
Then {TableB.Field}
Else {TableA.Field}
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
468
TPG_IT
T
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
672
dgillz
dgillz
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
547
doodledump
D
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
203
hilfy
hilfy
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
246
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top