Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 25th, 2016, 05:26 PM
Authorized User
Join Date: Apr 2009
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
Default Can I use a table as the criteria in a query?

I have multiple queries that do different things but they all need to identify if the part number is a kit or a stand alone part.

The problem is the list of kits is growing and every time a new kit is added I have to go in to *ALL* the queries and add the new item number.

So my question is can I use a table with the kit part numbers as my criteria?

Currently I am using an IIf statement to designate if the item is a kit or part.

example: IIf([Ordered Item] Like "ABC-*" Or [Ordered Item] Like "DEF-*" Or [Ordered Item] Like "GHI-*" ,"KIT","PART")

If I could use a table I would only need to update one location. Or does anyone have a different idea?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expressions in query criteria thedom Access 2 December 13th, 2007 04:33 PM
Conditional criteria in query dfuas Access 1 January 21st, 2006 03:39 AM
Criteria in Query lryckman Access 1 June 23rd, 2004 11:11 AM
Query Criteria Clive Astley Access 4 March 25th, 2004 03:27 AM
Append Query Criteria Ben Access 1 January 21st, 2004 07:24 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.