getting data from a database into a form
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!!!!!!!!!!!!!!!!!!! |
getting data from a database into a form
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 |
getting data from a database into a form
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!!!!!!!!!!!!!!!!!!! |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com