if then

  • Thread starter Thread starter HighEnder
  • Start date Start date
-----Original Message-----
iif([category] = "Strategic Supplier";1;0)



.
Sorry, but I missed the question. And it's comma not semi-
colon.

Yes, but only in the American English implementation of Access. In
most European languages the semicolon is correct.
 

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

Similar Threads

Use of the DSUM function 2
determining if a field should be included 6
Duplicated results 3
query too slow 1
Simple query?? 4
Parameter Query 7
conditional formatting 3
INDEX similar names in different rows 4

Back
Top