getting data from a database into a form

[brendan]

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!!!!!!!!!!!!!!!!!!!

 

[brendan]

Sorry all the database looks like this

ACC#..........CompanyName.........Wk1.........wk2.........Wk3..........wk4......Wk5ETC
123.............Company1................34.........100....
.....79............221......333
321.............Company2................21.........0......
.....0..............223......34
222.............Company3................0......... 342.....
...0...............0........55
111.............Company4................0...........0............334......
.....429......123
234.............Company5................0...........0............0..............456......0
ECT

 

[Teethless mama]

use VLOOKUP function