Field Value based on another Field

N

Night Owl

Hi,

I've got a form based on a query, which shows a series of Codes (A to T)
that relate to specific property types (e.g. A=Hotel, B=Factory, etc).

All I have is the data from a linked table that returns the Codes, but I
need to show another field that shows the types. This must be simple, but
it's been a while since I've played with Access....

Any help would be appreciated,

Peter
 
A

Andi Mayer

Hi,

I've got a form based on a query, which shows a series of Codes (A to T)
that relate to specific property types (e.g. A=Hotel, B=Factory, etc).

All I have is the data from a linked table that returns the Codes, but I
need to show another field that shows the types. This must be simple, but
it's been a while since I've played with Access....
Click to expand...

Join the tables.


If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
A

Andi Mayer

Ah - there isn't another table - or should I use a table as a reference?
Click to expand...
this would be the easier way or you add a field to the query:

IIf
(code="A","HOTEL",iif(code="B","noHotel,IIf(code="C","againNoHotel,
.............))) as MyString

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
N

Night Owl

Guess I'll go for the easy option then - there are 20 different codes!

Thanks,

Pete
 
Top