Where to use the "=" sign?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Milind - 16 Oct 2007 13:08 GMT

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?

Reply to this Message

Pieter Wijnen - 16 Oct 2007 13:26 GMT

yes, for control's source on a form or report

Pieter

> 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?

Reply to this Message

Jeff Boyce - 16 Oct 2007 13:27 GMT

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.

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

> 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?

Reply to this Message

John W. Vinson - 16 Oct 2007 18:05 GMT

>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?

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]

Reply to this Message