If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using = sign in expressions
When is it necessary to preceed expressions with the equal sign? It would
seem that the examples in MS help all use =, but when I view sample expressions within queries, the = is missing. I'm an old Excel user. Could someone explain when it is necessary to use the equal sign? |
#2
|
|||
|
|||
Using = sign in expressions
If I recall my Excel correctly, you preceed a function/expression with "="
in Excel, to let Excel know to do a calculation. In Access, you use "=" to "set" the value of one side of the equation to the other side. Regards Jeff Boyce Microsoft Office/Access MVP "jayceejay" wrote in message ... When is it necessary to preceed expressions with the equal sign? It would seem that the examples in MS help all use =, but when I view sample expressions within queries, the = is missing. I'm an old Excel user. Could someone explain when it is necessary to use the equal sign? |
#3
|
|||
|
|||
Using = sign in expressions
On Mon, 13 Mar 2006 12:52:48 -0800, jayceejay wrote:
When is it necessary to preceed expressions with the equal sign? It would seem that the examples in MS help all use =, but when I view sample expressions within queries, the = is missing. I'm an old Excel user. Could someone explain when it is necessary to use the equal sign? In a query, when you set a new column to an expression you would use NewColumnName:[FieldA]*[FieldB] In a report or form expression, you would start with an Unbound control. Then set it's control source to =[FieldA]*[FieldB] In VBA code, you would also use the = sign. VariableName = [FieldA]*[FieldB] -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
Using = sign in expressions
THANK YOU! I get it now.
"fredg" wrote: On Mon, 13 Mar 2006 12:52:48 -0800, jayceejay wrote: When is it necessary to preceed expressions with the equal sign? It would seem that the examples in MS help all use =, but when I view sample expressions within queries, the = is missing. I'm an old Excel user. Could someone explain when it is necessary to use the equal sign? In a query, when you set a new column to an expression you would use NewColumnName:[FieldA]*[FieldB] In a report or form expression, you would start with an Unbound control. Then set it's control source to =[FieldA]*[FieldB] In VBA code, you would also use the = sign. VariableName = [FieldA]*[FieldB] -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
EQUAL SIGN | K Nguyen | General Discussion | 2 | December 15th, 2005 07:30 PM |
Filtering and then comparing dates | Mike | General Discussion | 1 | July 29th, 2005 04:04 PM |
How do I write a large integral sign? | Andy | General Discussion | 1 | May 10th, 2005 01:08 PM |
euro sign in font | hstijnen | General Discussion | 1 | April 28th, 2005 09:08 AM |
Signing a VBA mde/mdb Access 2003 | John Buckett | General Discussion | 3 | July 3rd, 2004 09:14 PM |