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.Code:WHERE ([PackagesCosts].[TotalCost]) & [Forms]![F_Reports] ![Increased] & [C].[TotalCost])
What is the right syntax to manage this?