Look Up value in a query (1 Viewer)

[AnnPhil]

Can you use the DLookup function to look up a value in a query w/o putting in a criteria? Or is there another funtion that i should use.

Have a report that needs a value from a query but it not the record source of the report.,

 

[pbaldy]

Sure, but you'll get the value from the first record in the query. If that's okay, then you don't need a criteria.

 

[AnnPhil]

That's fine, how do i leave the criteria section, i tried the following but it didn't work

DLookup ("[fieldname]","[queryname]","")

Thanks

 

[pbaldy]

Leave it out completely:

DLookup("[fieldname]","[queryname]")

 

[mcmichael13]

I believe it should just be:

=DLookUp("[FieldName]","[QueryName]")

 

[pbaldy]

Good point; it does need the = as a control source.

 

[AnnPhil]

I sure feels stupid! I was forgetting the = sign, thanks everyone

 

[mcmichael13]

I sure feels stupid! I was forgetting the = sign, thanks everyone

no worries, i feel that way often haha