Query Expression

S

Shabbir

Hi,

I have a problem and have been trying to solve it for the past week! I hope
someone understands what i am trying to do and is able to point me in the
right direction ...

I have a query in which the 'ProductType' field displays a list of product
numbers e.g. 001;002;003;004 i want to be able to create another field in the
query which would look at the value in the 'ProductType' field and would
return a description e.g. 001 would bring up 'Motherboard' and 002 would
bring up 'PC Case' etc.

Any help will be extremely appreciated.
 
P

PC Datasheet

Include your Product Type table in the query and pull down the product type
description field.
 
Top