Access SQL / Get operator variable from from
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:
where [Forms]![F_Reports]![Increased] is the reference field in the combo box.
WHERE ([PackagesCosts].[TotalCost]) & [Forms]![F_Reports]
![Increased] & [C].[TotalCost])
What is the right syntax to manage this?