query ??

From: <Abeeda_Mohammed_at_xn.xerox.com>
Date: Fri, 19 Jun 1998 19:13:02 GMT
Message-ID: <6med7u$6ee$1@nnrp1.dejanews.com>

Hello,

I have two tables :

table a                        table b

partno                        count
grqty1                        mfgwk
grqty2                        day
grqty3                        month
grqty4                        year

For table a the field gross qty goes from 1 to 84, i.e grqty1,grqty2,grqty3..grqty84 i.e gross qty from week 1 to week 84

The table b has 84 rows each of which correspond to a week. The count field in table a ranges from 1 to 84.

How to write a query so that I will be able to extract the gross qty for 20th week or the 30th week etc;

Thank you,

Abeeda

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 19 1998 - 14:13:02 CDT