Creating a price list report

[ablettablet]

Hi Guys

I've been put in charge of creating a database specific to our company which has been brilliant and a very steep learning curve!! But a brilliant challenge!! We've just added in our product list from which I run a report to print off a price list for our customers. I have one slight niggle in that some of our products need to show in the price list but as yet we don't have stock and therefore no selling price. The field for the selling price is blank in the table, when I run the report naturally this is showing blanks when we don't have a selling price. My question is ......

Is it possible to get a blank field to show POA and if so how?

Thanks for any help you can give.

Vx

 

[ablettablet]

Should say that the field has been set to currency.

 

[vbaInet]

It's showing blank or that record is not showing at all?

If it's blank look into the Nz() function. Else, you will need to change your JOINS.

 

[Pat Hartman]

The format property has three settings separated by the semi-colon - positive;negative;null.
You can use POA as the "null" value.
* #,##0.00;* (#,##0.00);* POA

 

[ablettablet]

Thanks guys for your help, I ended up using an IIF statement but had to convert the field to text as it could only deal with either all text or all currency.

IIF statement I used was -

Direct Price: IIF([Control1]="0","P.O.A.",[Control1] could also have used IIF([Control1] Is Null, "P.O.A.",[Control1])

But thanks for your help. really appreciate this little community, learning the brilliance of Access constantly. :-D

 

[Pat Hartman]

Converting the field to text to solve a display issue isn't the answer. Now you won't be able to do arithmetic with it or use aggregate functions. Try the format I gave you. I just guessed at what you need. Review the details in help if my example gave you an error.