Recent content by mikmonto

Hero! It worked perfectly. Thanks, M

Thanks Plog, Just tested it but actually not working yet WEAVEPR = DAvg("Speed", "WIP_GANTT_WEAVE_PR", "[Type] ='" & Forms![WIP_GANTT]!LoomType & "'' And [Location] ='" & Forms![WIP_GANTT]!Country & "'") (Just changed DLookup with DAvg, but I had the same error with DLookup) Thanks, M

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 CJ, Thanks for this! Sorry for annoying you, but the explanation of what I need to do does not sound familiar at all to me. Can you please be more descriptive? Bear in mind I am using Access 2010. Thanks, M

Sorry, I think we have to go back to the original request. WHERE (((([PackagesCosts].[TotalCost]) & [Forms]![F_Reports]![Increased] & [C].[TotalCost]) Meaning Where TABLE.FIELD1 < > TABLE.FIELD2 and the < > is given by [Forms]![F_Reports]![Increased]

[Forms]![F_Reports]![Increased] is exactly a character (eg < or > or =) This can have generated confusion

"Return all records where [PackagesCosts].[TotalCost] [Forms]![F_Reports]![Increased] [C].[TotalCost]" with [Forms]![F_Reports]![Increased] being < , > or =

It may sound confusing, but the field [Forms]![F_Reports]![Increased] is actually the operator (< or > value) of the where clause. This is because on the same report I want to show two different scenarios.

Hi CJ, thanks for the prompt response. Actually the filed [Forms]![F_Reports]![Increased] will provide values "<" 0 or" >" and it is used to compare the other 2 fields [PackagesCosts].[TotalCost] and [C].[TotalCost] Does this change the query in any extent?

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...