Urgent help needed

[Infamous]

Hi,

I'm having some trouble with a report I am responsible for. I'm novice to Access, so if you could please explain in detail...that would be great.

Well, I am supposed to create a report, that will pickup data from 1 table (Passport_details), and display them in a report. Within the passport Details table, there are 3 fields (Scrap, Resale and RTS). For each record, their will only be a number in one of these fields. For example:

Product status: **here is where Scrap, Resale or RTS goes"
PassportID Product Scrap Resale RTS
123456 Battery 9 0 0
987654 Pots 0 7 0
456789 Knives 0 0 3
etc.


What I want is a textbox or label at the top that will state "Scrap" if there's a value other than 0 in the Scrap Field....."Resale" if there's a value other than a 0 in the Resale Field, and "RTS" if there's a value other than a 0 in the RTS field. There isnt occurences where their may be a value for two of Scrap, Resale or RTS...its either one of them.

I'm sure this is simple for the experts within this forum, but I could sure use the help.

Thanks,
Infamous

 

[WayneRyan]

in,

Add two new field's to your report's query:

YourLabel: IIf("[Scrap] <> 0", "Scrap", IIf("[Resale] <> 0", "Resale", "RTS"))
YourValue: IIf("[Scrap] <> 0", [Scrap], IIf("[Resale] <> 0", [Resale], [RTS]))

Wayne

 

[WayneRyan]

Pat,

Good catch!

So many languages ... so little time!

Thanks,
Wayne