UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> #name?    
 
   
slickvick
post Apr 3 2012, 08:34 AM
Post #1

UtterAccess Addict
Posts: 236
Hello,

I created a text box on a form for display the following total:

=[qryProjectsOpenTotalsLeadsCount]![Total Calls]

I get a #name? result.

Why?


Any help is appreciated.


Vick.
Go to the top of the page
 
+
MiltonPurdy
post Apr 3 2012, 08:42 AM
Post #2

UtterAccess Ruler
Posts: 1,621
From: Arkansas
If this is a formula, you would not use the !

If it is multiplication, use *

Addition us +

Etc.
Go to the top of the page
 
+
slickvick
post Apr 3 2012, 08:47 AM
Post #3

UtterAccess Addict
Posts: 236
Thank you for the reply,


It is from the control source ---> expression builder ----> I selected the field I want to be displayed.


I'm not sure if this is the way to do it though.
Go to the top of the page
 
+
arnelgp
post Apr 3 2012, 08:55 AM
Post #4

UtterAccess Ruler
Posts: 1,090
you cannot reference a query directly like that, instead you can:

=DLookUp("Total Calls", "qryProjectsOpenTotalsLeadsCount")
Go to the top of the page
 
+
slickvick
post Apr 3 2012, 09:04 AM
Post #5

UtterAccess Addict
Posts: 236
Arnelgp, I got an #error...(IMG:style_emoticons/default/frown.gif)
Go to the top of the page
 
+
slickvick
post Apr 3 2012, 09:10 AM
Post #6

UtterAccess Addict
Posts: 236
Got it, It was missing the brackets [].


Thank you!!!!
Go to the top of the page
 
+
arnelgp
post Apr 3 2012, 09:15 AM
Post #7

UtterAccess Ruler
Posts: 1,090
Good eye sight you have and quick reflexes.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 06:07 PM