Excel to Access

[Guest]

I have a complex Excel sheet with several formulas. Can I transfer those
formulas into Access? Or Can I build a form or report that is ran off of
queries.

Some of the formulas I have answer these questions
Total Cancelled byt Month
Total Cost to Cancel
Avg Cost to Cancel ( Sum of Cost/Sum of Count Cancelled.)

Thanks

 

[Douglas J. Steele]

You'll have to create queries in Access, and add the formulae to the
queries. There's no way to automate the process, I'm afraid.

Once you've got the formulae in your queries, you can build forms and
reports off them.

 

[dbahooker]

Excel is for retards.

Fire everyone at every company that uses Excel for ANYTHING and then
take their salaries and hire a couple more db people.

-Aaron