Queries with selected data

[Guest]

Hello,

I have 2 columns that contains items category and product type. My table
reads like this

"SKU" "Item Category" "Product Type" etc

In items Category, I have 4 different field names (DVD, VHS, UMD, GAM).

In Product type, I have 5 types (BLU, DVD, GM, HD and VHS).

I want to create seperate queries where I will have only SKUs with "DVD" and
"DVD" (Query1), "DVD" and "BLU"(Query2), "DVD" and "HD"(Query3), "UMD" and
"DVD"(Query4), and "GAM" and "GM"(Query5).

Any input will be appreciated.


Regards

Stephan

 

[John Vinson]

In items Category, I have 4 different field names (DVD, VHS, UMD, GAM).

In Product type, I have 5 types (BLU, DVD, GM, HD and VHS).

I want to create seperate queries where I will have only SKUs with "DVD" and
"DVD" (Query1), "DVD" and "BLU"(Query2), "DVD" and "HD"(Query3), "UMD" and
"DVD"(Query4), and "GAM" and "GM"(Query5).

Pretty easy. Just create a Query based on your table; select the SKU,
Type and Category (and any other fields you want to see); on the
Criteria line under Product Type put

"DVD"

and again put "DVD" on the Criteria line under Category. Save this as
Query1. Do the same logic for the others.

Or... perhaps better... use a Parameter query. Put

[Enter product type:]

on the criteria line under Product Type, and

[Enter category:]

under the Category. You'll be prompted when you open the query (or
when you open a Form or Report based on the query), so you can get all
five queries for the price of one.

John W. Vinson[MVP]