Dlookup

[syedadnan]

I have a query name achv_targets and having fields like "targetmonth" which is from format of field "Targetdate" i have another field "VanName"

now in another query name e_Sales i want a dlookup from the first query i.e. achv_targets where dlookup to put result based on criteria of "VanName" and "TargetMonth" both of these fields are text

 

[boerbende]

It is not clear to me what you want. Maybe you can describe your question differently?

 

[jdraw]

And post your sql.

 

[syedadnan]

It is not clear to me what you want. Maybe you can describe your question differently?

Here is the attached image of the query "achv_targets" and its field,

In a new query named "TM" i need dlookup from this query named "Achv_targets"

like this but not knowing the exact criteria !!!

DLookUp("targetfigure","achv_targets", ????? '") required targetfigure to dlookup in query TM with criteria to see "targetmonth", "Vanname"

Note: targetmonth field is actually targetdate which is formated by this formula TargetMonth: Format([targetDate],"mmm-yy")

 

[arnelgp]

what are the corresponding fields in e_sales?

 

[syedadnan]

what are the corresponding fields in e_sales?

Thanks for the reply here is the whole program attached,

what i want is in query e-sales i want a field to show targets from query achv_targets with respect to "targetmonth" and "van" from query achv_targets

where as in e-sales query both fields are with the name "tmonth" and "van"

 

[arnelgp]

please try this

 

[syedadnan]

please try this

Its being the perfect ... great .. thanks alot