If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tables & Formulas
Hello,
My company tests candidates and / or existing staff members for our clients. Currently for each person there is an Excel document created from a template that we work off. The Excel template contains loads of very complex formulas the result of which is displayed graphically for the client. I want to create a database to give to the client where they can see the graphical information for any given staff member and / or candidate at the click of a button. My problem is that I don't know how the formulas in Excel can work in Access as I'm fairly new to it. What I CAN quite easily do is use a macro in Excel to extract the final data needed for the graphs and then import this info into a table in Access. This would work fine for the time being but for future clients and our own use I think it would be best if the database can calculate the data each time as it is needed instead of storing it. The only data really needing to be stored is the candidate info and the raw scores, as from the raw scores we can generate scores for traits, behaviours, competencies etc. My self taught experience so far with Access is that it's the best thing since sliced bread especially if you know what you are doing which, when it comes to code, I don't . Any input would be greatly appreciated - even if someone can steer me in the right direction by recommending a book or web site where I can fumble around and learn these things myself. Thanks in advance. Regards, Averil |
#2
|
|||
|
|||
Tables & Formulas
You can't store formulas in tables. It's as simple as that.
What you can do is create a query that includes the formulas as computed fields, and use the query wherever you would otherwise have used the table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "Averil Pretty" wrote in message ... Hello, My company tests candidates and / or existing staff members for our clients. Currently for each person there is an Excel document created from a template that we work off. The Excel template contains loads of very complex formulas the result of which is displayed graphically for the client. I want to create a database to give to the client where they can see the graphical information for any given staff member and / or candidate at the click of a button. My problem is that I don't know how the formulas in Excel can work in Access as I'm fairly new to it. What I CAN quite easily do is use a macro in Excel to extract the final data needed for the graphs and then import this info into a table in Access. This would work fine for the time being but for future clients and our own use I think it would be best if the database can calculate the data each time as it is needed instead of storing it. The only data really needing to be stored is the candidate info and the raw scores, as from the raw scores we can generate scores for traits, behaviours, competencies etc. My self taught experience so far with Access is that it's the best thing since sliced bread especially if you know what you are doing which, when it comes to code, I don't . Any input would be greatly appreciated - even if someone can steer me in the right direction by recommending a book or web site where I can fumble around and learn these things myself. Thanks in advance. Regards, Averil |
#3
|
|||
|
|||
Tables & Formulas
The other thing you could do is open the Excel file from Access and read in the information off the spreadsheets. That's fairly easy to do. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
Tables & Formulas
The other thing you could do is open the Excel file from Access and read in the information off the spreadsheets. That's fairly easy to do. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#5
|
|||
|
|||
Tables & Formulas
The other thing you could do is open the Excel file from Access and read in the information off the spreadsheets. That's fairly easy to do. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#6
|
|||
|
|||
Tables & Formulas
The other thing you could do is open the Excel file from Access and read in the information off the spreadsheets. That's fairly easy to do. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#7
|
|||
|
|||
Tables & Formulas
The other thing you could do is open the Excel file from Access and read in the information off the spreadsheets. That's fairly easy to do. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|