IIF Statement In Query

[Darknight850]

Hello Every One,

I am having a problem with an IIF statement in a query I have going. Before I start I would like to say I have had some problems in the past with supplying enough information, if you need more information just ask and I'll try my best to give it.

What i have is a query that is beeing used for a weekly report, this weekly report is broken down in weeks, using the following code "

 CStr([Date Of Arrival]-Weekday([Date Of Arrival],6)+1) & " - " & CStr([Date Of Arrival]-Weekday([Date Of Arrival],6)+7) AS WeekPeriod

"

The next part counts the number of arrivals that week period and then counts the number of individuals that get Permanent IDs(PermID)(Che ck Box) as the days go on.

What I need the IIF statement to do is count the individuals that do not have a Permanent ID that are on vacation(Vacati on), this way we can see why every one has not gotten a Permanent ID.
Example:
If John Doe, arrived on march 31st, went on vacation, and never picked up his permenant ID then in that field it would count 1
I tried the following

IIF([PermID]) = 0, Sum(Vacation)*-1, 0)

But I keep getting an error.

I relize that this question is fairly simple and for some reason it is just not working so I figured get a cupple people to look at it and put in there 2 cents.

Table Structior:
tblAll:
EmployeeID - PK - Auto Number
Name
PermID - Check Box
Vacation - Check Box

If there is any other information that is needed then please just ask I am sorry if i have left out anything importent, but as far as I know for the question that I have stated that is more then enough info.

P.S. This is going to prob. be my last question, since I will be handing this Database over to some one else, I just wanted to take this chance to thank every one that has helped me on these Odd and frustrating questions that I have asked, It has been a great help.
Thank You Again

[Stwange]

Instead of:
IIF([PermID]) = 0, Sum(Vacation)*-1, 0)

Try:
Sum(IIf([PermID] = 0, Vacation * -1, 0)

Unless I am misunderstandin g you.

Also, note that you have closed the bracket too early on your example, it should read IIF([PermID] = 0, Sum(Vacation)*-1, 0)

Good Luck.