ok, I have a table that has Items in Rows and Style's in Colums:
ITEM STYLE A STYLE B STYLE C STYLE D STYLE E STYLE F STYLE G STYLE H 1 $1.00 $2.00 $3.00 2 $2.00 3 4 $1.00 $3.00 5 6 $5.00 $6.00 7 $1.00 8 9 $2.00 $3.00 10 $1.00
I have a form that has two list boxes:
I want to Choose the Item and then have the Style Listbox only show Style's that have a price in them.
This table has 406 Rows and 72 colums
I can do this in excel, but i'm not a Access Programmer and using MS Access 2003.
how do i build this query?
Thanks in advance
JL