creating an expression in a View in an Access Project

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top