Where to use the "=" sign?

M

Milind

Unlike in Excel where the "=" is must for equations, in Access is there such
a condition? I find you just build up a condition in the Builder for
calculated fields or conditions. Is "=" used like Excel in Access?
 
J

Jeff Boyce

Where are you trying to do this? What happens when you try it?

If you are creating an expression for a new field in a query (design view),
you wouldn't need to use the "=".

If you are putting an expression in a form's (or report's) control's Control
Source, you would.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
J

John W. Vinson

Unlike in Excel where the "=" is must for equations, in Access is there such
a condition? I find you just build up a condition in the Builder for
calculated fields or conditions. Is "=" used like Excel in Access?
Click to expand...

Excel is a spreadsheet. Access is a relational database. THEY ARE DIFFERENT!

Access is *not* "Excel on steroids". For one thing, you cannot and should not
put expressions or calculations in a Table. Tables are for data storage. You
can do calculations in a Query by typing

YourDesiredFieldName: [X] + [Y] + [Z]

or whatever expression you want in a vacant Field cell in the query design
grid.

Stop, step back a bit, and learn how Access works; trying to coerce it into
being a "flawed implementation of Excel" will get you nothing but headaches.
See

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

for some introductions.

John W. Vinson [MVP]
 
Top