Conditional statement assist

[JSDART!!]

Hi
I have a booking database that I am building
when you go to book a bed you enter the bed number and another query runs showing you all the beds in that room and if they are booked if they are male or female. can only have one gender per room.
when the bed is released and made available for booking again is when the problem occurs.
the query looking at the other beds in that room shows that the bed is available but the last gender that was in the bed is still attached.
I believe that I need to do some type of IFF statement
saying that iff [Avail]= true then [bookedg]= is null. but cant quite seam to get the syntax.
any help greatly appreciated.
J

 

[workmad3]

It sounds like a problem with the code that is freeing the bed. As you are most likely storing the gender in the database, make sure that the gender is set back to null or an empty string when the bed is made free, and also check that zero length strings are allowed in that field.

Other than that, just use a normal if statement if you wish to use one. i.e

If [Avail] Then
bookedg = Null
End If