reserved words

[blake7]

Hi all,
I am running a query which run ok, the query returns a column that is
counting the words "Full Function" from a table, the results are working ok,
but when I add these results to a report text box with the code DLookUp("Full
Function","Year To Date Summary") it returns the #Error due to the words
"Full" and "Function" being reserved words in access, is there anyway around
this problem so that it will allow me to use these words, I really dont want
to change the words "Full Function" within my database as this would create
so much extra work. Thanks

 

[Al Campagna]

Blake,
See my response to your later post of 1/9 7:39am...
Please don't don't post the same question twice, in such
a short time. Responders are volunteers, and you just have
to have a bit of patience.
Response times within the Access NGs are very good, but
never guaranteed.
Thanks...
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John Spencer]

I don't think the error has to do with the words being reserved, but with the
fact that you have a space between them.

Try surrounding the field and table/query names with brackets.
DLookup("[Full Function]","[Year To Date Summary]")


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County