Search results

Hi, I have an issue with a DLookup: WEAVEPR = DLookup("Speed", "WIP_GANTT_WEAVE_PR", ("Type =" & "Forms![WIP_GANTT]!LoomType") And ("[Location] =" & "Forms![WIP_GANTT]!Country")) Both LoomType and Country are Text If I use just one of the two conditions, the DLookup works, otherwise it does...

Hi, I need to have the comparison variable (< or >) to be read from a field in the form. Namely: WHERE (((([PackagesCosts].[TotalCost]) & [Forms]![F_Reports]![Increased] & [C].[TotalCost]) Where [Forms]![F_Reports]![Increased] is the filed on my form. What is wrong in the syntax (as it is...