Printing Blank Values

[malk]

I am trying to write a check register report. One of the fields is the vendor number field. For some reason, if there is no vendor number it doesn't print a record for that check. I am not selecting by vendor number nor am I sorting.
What I think I need is a formula field to print in stead of "vendor.number", that will give me the vendor number if it exists, and write "One Time Vendor" for "Vendor.Number" and "Vendor.Name", and print that record.
I may be wrong about needing that formula field, but if you have any suggestions, or help writing that formula please Respond.

 

[MalcolmW]

If there is no vendor number, what value does the vendor number field contain?
Is Vendor.Number a string or a number?
Check out the IsNull() function in the online help - there are some formula examples there. I suspect you will need to trap null values in your formula. Malcolm

 

[malk]

Venodr.number and vendor.name are strings. I wrote this function just now:
if (isnull({CHKREG_CSV.VENDOR#NUMBER }) = true) then
({CHKREG_CSV.VENDOR#NUMBER }= "One Time" and {VENMAST_CSV.VENDOR#NAME } = "One Time&quot


but how would I use the results to print the Vendor number and name?

 

[MalcolmW]

there are a few syntax issues with your formula, but first
is {CHKREG_CSV.VENDOR#NUMBER } a number or string?
Malcolm

 

[malk]

a string

 

[MalcolmW]

I must be blind - missed that from your previous post.
Anyway, this formula will work to produce the vendor number:
if isnull({CHKREG_CSV.VENDOR#NUMBER } then
"One Time"
Else
{CHKREG_CSV.VENDOR#NUMBER }
A similar formula can be used for vendor name
if isnull({CHKREG_CSV.VENDOR#NUMBER } then
"One Time"
Else
{CHKREG_CSV.VENDOR#NAME }

Do you have a record selection formula as well? Malcolm

 

[malk]

the problem is, is that it is not null. It is a linked database. The checkmaster and vendormaster are linked by vendor name, so the logic would have to be:
if invoicemaster.vendor.number is null
then vendormaster.vender.name = "one time vendor".
I've been trying, and I can't get it.