B
Burton
am trying to write a query in Access, but I am having problems. If I write
it like this:
IIf([Forms]![Form1]![Option22]=True,[Forms]![Form1]![Text6], "") than it
works just fine.
However, as soon as I add a > or < sign in the code, it stops working. This
is what I want it to say:
IIf([Forms]![Form1]![Option22]=True,>=[Forms]![Form1]![Text6], "").
Do you know why the > causes the query not to work? Do you know how I can
fix it?
it like this:
IIf([Forms]![Form1]![Option22]=True,[Forms]![Form1]![Text6], "") than it
works just fine.
However, as soon as I add a > or < sign in the code, it stops working. This
is what I want it to say:
IIf([Forms]![Form1]![Option22]=True,>=[Forms]![Form1]![Text6], "").
Do you know why the > causes the query not to work? Do you know how I can
fix it?