Help needed with textboxes

[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

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

 

[MStef]

Hello Infamous!

Look at "DemoRTSA2000.mdb".
Look at Table1, Report1 (VBA).
I think it is vhat you need.

 

[Infamous]

I can't see it because I'm using Access 97...i know, its an old version but thats what I'm provided with. If someone could explain me what to do, that would be very helpful

 

[RuralGuy]

Here it is in a97 format.