Tables & Formulas

[Averil Pretty]

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

 

[Douglas J. Steele]

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.

 

[dandgard]

The other thing you could do is open the Excel file from Access and rea
in the information off the spreadsheets. That's fairly easy to do

 

[dandgard]

The other thing you could do is open the Excel file from Access and rea
in the information off the spreadsheets. That's fairly easy to do

 

[dandgard]

The other thing you could do is open the Excel file from Access and rea
in the information off the spreadsheets. That's fairly easy to do

 

[dandgard]

The other thing you could do is open the Excel file from Access and rea
in the information off the spreadsheets. That's fairly easy to do

 

[dandgard]

The other thing you could do is open the Excel file from Access and rea
in the information off the spreadsheets. That's fairly easy to do