I want the user to be able to type in < > or = and a number into a text box and use that expression in the where clause of a query. However, it seems that whenever there is an operator in the text box it doesn’t return any values. Is there any way to have a user select between < > or = and type in a number? Should I just make one text box for each operator?
SQL:
SELECT Distributor_Stats.HD_DIST_NAME, Distributor_Stats.DIST_ID, Distributor_Stats.PROMO_COUNT,
FROM Distributor_Stats
WHERE (((Distributor_Stats.PROMO_COUNT) Like IIf([forms]![frm_resub_report]![txtpromo]="ALL","*",[forms]![frm_resub_report]![txtpromo].[value])));
SQL:
SELECT Distributor_Stats.HD_DIST_NAME, Distributor_Stats.DIST_ID, Distributor_Stats.PROMO_COUNT,
FROM Distributor_Stats
WHERE (((Distributor_Stats.PROMO_COUNT) Like IIf([forms]![frm_resub_report]![txtpromo]="ALL","*",[forms]![frm_resub_report]![txtpromo].[value])));