DLookUp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Glad to see I'm not the only one struggling with this. Getting the #Error.

=DLookUp([Freq],"[Staff Performance Table]","[Matrix]='5A'")
 
If Freq is a field name then use:

=DLookUp("[Freq]","[Staff Performance Table]","[Matrix]='5A'")
 
Thank you. I guess this is a report thing. Even though [Freq] is a numeric,
it needs "". I just tried that in another calculation in a report and that
made it work as well. I really appreciate the info!

Duane Hookom said:
If Freq is a field name then use:

=DLookUp("[Freq]","[Staff Performance Table]","[Matrix]='5A'")

--
Duane Hookom
MS Access MVP
--

Connie said:
Glad to see I'm not the only one struggling with this. Getting the
#Error.

=DLookUp([Freq],"[Staff Performance Table]","[Matrix]='5A'")
Click to expand...
Click to expand...
 
This isn't "a report thing". It is the basic requirements of domain
aggregate functions.

--
Duane Hookom
MS Access MVP


Connie said:
Thank you. I guess this is a report thing. Even though [Freq] is a
numeric,
it needs "". I just tried that in another calculation in a report and
that
made it work as well. I really appreciate the info!

Duane Hookom said:
If Freq is a field name then use:

=DLookUp("[Freq]","[Staff Performance Table]","[Matrix]='5A'")

--
Duane Hookom
MS Access MVP
--

Connie said:
Glad to see I'm not the only one struggling with this. Getting the
#Error.

=DLookUp([Freq],"[Staff Performance Table]","[Matrix]='5A'")
Click to expand...
Click to expand...
Click to expand...
 
Back
Top