get a value from query in my report!!

[ccguillermo]

Hi,
First i want to apology for this i already post this problems last week and two day ago on some place else. The problems is that I try to get a value from field on my report from a query;
But when I did the DlookUp Function:
=Dlookup(“Filedname”, :QueryName”, “UserID = “ & [UserId])
I get a #errror in my reports and I try to do thios too to see if I can get some value but nothing
=Dlookup(“Filedname”, :QueryName”)


And get the same #error and not the values; I don’t know if the problems is the the value of the field is a calculate field that I call [T-850].
I really appreciate you time and you help.
Thank you


Carlos

[pbaldy]

Well,

:QueryName”

should be

"QueryName”

[ccguillermo]

hi
Thank you for you replay but it is a typo. when I type the message.

Thank you

[pbaldy]

What is the data type of UserID in the table? Have you double checked the spelling of the table/query/field names?

Just an FYI, it's always best to copy/paste things from your application to here, to avoid that kind of thing.