M
mark
I'm having a problem with the syntax for a View. For example, in a query of
an Access Database (.mdb), I could create a field called Diff like the
following:
IIF([FieldA] = [FieldB], Null, "***") as Diff
But when i do something similar in a View of an Access Project (.adp) it
doesn't like my syntax. It doesn't like my equal sign and where I have
double quotes, they get changed to bracketts (on the above new field, and in
other examples).
Thanks,
~Mark
ps: I thought I was in the right forum to post this message, but than had to
select a discussion group; I don't know if I selected the appropriate one
an Access Database (.mdb), I could create a field called Diff like the
following:
IIF([FieldA] = [FieldB], Null, "***") as Diff
But when i do something similar in a View of an Access Project (.adp) it
doesn't like my syntax. It doesn't like my equal sign and where I have
double quotes, they get changed to bracketts (on the above new field, and in
other examples).
Thanks,
~Mark
ps: I thought I was in the right forum to post this message, but than had to
select a discussion group; I don't know if I selected the appropriate one