Query Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Include your Product Type table in the query and pull down the product type
description field.
 
Back
Top