save a entry in database for the items in list
I want to create these fields:
coloumn a: a drop down list of names column b: drop down list of dates column c: drop down list of some numbers and alphabets I want to corelate all these three columns for the item selected. eg: if i select name "john" from column a and "1/1/6" from column b and select "4" from coumn c then i need a report generated which will mention "john" on "1/1/6" had "4" units and "john" from "1/1/6" to "31/1/6" had "?? total units" Can some one help create the same. |
save a entry in database for the items in list
Hi Dr. Akash Rajpal,
See my Excel database tutorial at http://www.edferrero.com/DataTutor01.aspx Ed Ferrero Microsoft Excel MVP http://www.edferrero.com I want to create these fields: coloumn a: a drop down list of names column b: drop down list of dates column c: drop down list of some numbers and alphabets I want to corelate all these three columns for the item selected. eg: if i select name "john" from column a and "1/1/6" from column b and select "4" from coumn c then i need a report generated which will mention "john" on "1/1/6" had "4" units and "john" from "1/1/6" to "31/1/6" had "?? total units" Can some one help create the same. |
All times are GMT +1. The time now is 04:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com