Conditional Adding

[Bloodrayne]

Hello again,

In my report I have Flight_requested, and Flight_booked (both tick boxes) - What I need to know is, is there a way so that if Flight requested is ticked and flight booked isn't, the totals at the end add one to the flight requested tally - however, if both requested and booked are ticked, only booked is added to?

I hope that's clear enough, if you need any more information, just ask and I shall provide

Thanks!

 

[Bloodrayne]

After thinking on about this one, I realise that I need something along the lines of:

Count
If (Flight requested = 1 & Flight booked = 0)

But I don't know where to find the appopriate Access commands.

The logic of the above would work though, right?

 

[Bloodrayne]

=Sum(IIf([Flight Requested] And Not [flight booked],1,0))

Seems to work fine, would it cause any problems?