Using Equations in Access

  • Thread starter Thread starter Simon Burke Scottish & Newcastle
  • Start date Start date
S

Simon Burke Scottish & Newcastle

Hi - I use excel a lot and have a database of potential buisnesses to keep
track of. I use excel and have formulas which show profit and turnover
relationships and the like. I have not used access before but wanted a form
platform to view data with ease. Problem is that I import the excel file but
the formulas do not work. How can I get them to work?
 
Access is not a substitue for Excel. It is a totally different animal.
Access is an application development environment for relational database
applications. Most likely, your imported data in not correctly normalized.
For the time being, that may be okay, but as your needs change and grow, it
will, over time, become weidly and difficult to get the desired results.

The short of that is, the first thing to do is review your data in light of
relational database normalization. Once you have established a relational
model, you are ready to move on.

As to you formulas, there are equivilant functions in Access for those
things you can do in Excel. The names may be different or thins with the
same name may do different things. If you review the availabe functions in
VBA Help, you will probably find most of what you need there.

And, you are always welcome to post specific questions in these newgroups
when you need additional help.

Best of Luck.
 
Still do not get it? These newsgroups are provided by Microsoft for FREE
peer to peer support, not as a venue to sell your hollow promises.

Please just go away.

John.. Visio MVP
 
Back
Top