Field Value based on another Field

[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

 

[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....

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

 

[Night Owl]

Ah - there isn't another table - or should I use a table as a reference?

Peter

 

[Andi Mayer]

Ah - there isn't another table - or should I use a table as a reference?

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

 

[Night Owl]

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

Thanks,

Pete