Hi,

I am quite new to Access, therefore I will try to be as clear as possible.
I am writing a query to be used by a report. In a WHERE condition I would need the operator (< or >) to be taken from a combo box on the form where the report is.

Namely, the condition is:
Code:
WHERE ([PackagesCosts].[TotalCost]) & [Forms]![F_Reports]
![Increased] & [C].[TotalCost])
where [Forms]![F_Reports]![Increased] is the reference field in the combo box.

What is the right syntax to manage this?

Thanks,
M