Option Group

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

Guest

When using an option group in a form by assigning each catagory a number.
How can we pull up the catagory name instead of the number in a query.
 
Create a Category table. Two fields CatID and CatDescr
CatID would be the field that would match the category number and CatDescr
would be a text field with the name. Include the table in your query joined
on CatID
 
Thank You
--
Rose


Klatuu said:
Create a Category table. Two fields CatID and CatDescr
CatID would be the field that would match the category number and CatDescr
would be a text field with the name. Include the table in your query joined
on CatID
Click to expand...
 
You must log in or register to reply here.

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

query syntax error 1
looking for multiple values in a table 4
to display specific group by result in Crosstab query 13
Help w/Query 4
Combine Multilple Tables 7
Need some help at adding new table in query 2
How do I create a word web? 1
multiple catagories for 1 member 2

Back
Top