Hi all,
i am trying to create a form from a database.

in the first col is the account #.
in the second is the company name
and in the third to fiftyforth is each weeks spending

what i want to extract is first 3 weeks spend

ie.

ACC#..........Company
Name.........Wk1.........wk2.........Wk3.......... wk4......Wk5 ETC
123.............Company
1................34.............100........79..... .......221......333
321.............Company
2................21.............0.............0... ...........223......34
222.............Company
3................0................342.......0..... ..........0...........55
111.............Company
4................0................0............334 ..........429......123
234.............Company
5................0................0............0.. .............456......0
ECT

i want a form that will tell me what week company first first traded. the
form needs to look somethin like this

Company Name: Company 2.............ACC#: 321

week........spend
1..............21
4..............223
5..............24

i have figured out how to get the Company Name and other details in there by
only typing the account#, but i cant get the info above.

can someone please help me!!!!!!!!!!!!!!!!!!!