jeudi 15 septembre 2016

MS Access query criteria based on field from form

I am banging my head against a wall on this one. How do I get an operator to work in a query criteria based on a form field. Ideally I would like it to be something like:

IIf([Afloat]="No",<[Forms]![DASF]![Text222],"")

When I remove the operator it finds anything exactly to the criteria in that field but the moment I try to put an operator like greater than or less than it does not work. I am trying to find all records less than the value in that form field.

Any advice on how I can fix this? Or is it not possible in MS Access? Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire