I am running a report that pulls its information from a query. Is it possible to do a DLOOKUP in the report to pull information from the query. Here is the syntax I have.
The fields in the query are as follows:
Query Name: Report
Material
Old Matl
Material Description
Mvt
Post Date
Quantity
Also, Will I be able to usa a DLOOKUP on a different table to pull in more information?
Thanks,
Meliss@
Code:
=DLookUp("[SUMOFQUANTITY]","REPORT","[OLD MATL] = BOT30026SS")
The fields in the query are as follows:
Query Name: Report
Material
Old Matl
Material Description
Mvt
Post Date
Quantity
Also, Will I be able to usa a DLOOKUP on a different table to pull in more information?
Thanks,
Meliss@