Query same category id

  • Thread starter EMILYTAN via AccessMonster.com
  • Start date
E

EMILYTAN via AccessMonster.com

May i know how to query all the jobnumber where it is in the same category ID?


Because I want to use this as my list in combo box
 
J

Jeff Boyce

I'm not clear yet what you are trying to achieve.

One interpretation of your question would be that you wish to group by
category ID. Another could be that you want to find jobnumbers that fall
into a (pre-selected) category ID.

Have you tried creating a new query that includes your conditions
(selection), then using that query as the source for your combo box?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
J

John W. Vinson

May i know how to query all the jobnumber where it is in the same category ID?


Because I want to use this as my list in combo box
Click to expand...

How do I find all the cars in Idaho that are the same as?

Emily, you need to post more information when you ask questions. It is very
hard to understand what you mean. The same Category ID as... *what*?

John W. Vinson [MVP]
 
Top