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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help writing query to sum groups 4
querie Criteria date range and find records on ProductType 1
Help with nulls, Nz, etc 5
Query - Show One of Everything 3
Record output in queries 1
how do i perform a Count(Distinct) query for 2 different column va 1
Build an order 3
help needed with writing a bit of code 2

Back
Top