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

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

use VLOOKUP function

"brendan" wrote:

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