I want to subtract values of two different fields. I tried to do calculations
similar to excel by typing '=' followed by add or subtract. But it is not
working. How to solve in access.
Krishna
Excel is a spreadsheet, best of the breed.
Access is a relational database.
THEY ARE DIFFERENT. An Access table may look superficially like a spreadsheet,
but it is NOT a spreadsheet, and does not work like one. In fact, in a
production Access database you will probably never even SEE a table datasheet!
To do calculations, you can create a Query based on the table, and put
expressions such as
SumOfAAndB:[A] +
in a vacant Field cell in the query design grid. Or, you can use an expression
in the Control Source of a textbox on a form or report:
=[A] +
Do learn how Access (and relational databases in general) work. They require
different thinking than spreadsheets, and can easily do some things that
spreadsheets cannot do at all, or only with great difficulty (the reverse
applies, too; there are many tasks for which spreadsheets are ideal and
databases struggle).
Here's some references that might help:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
