help in if

[do0ot]

hi guys
im creating a parking system in ms acess but i need a help in the querys plz
ok first let me explain
i have a field called USERID , arrival time , leave time , fees

i want a code to write that : IF the USERID start with "IN" in the fees will type free
else
if the time between arrival and leave more than 1 hour in the fees will write 1$ it is possible to do it ?
plz help me ASAP i have a proejct to submite it

 

[do0ot]

now its giving me all the fees are free :S

 

[do0ot]

ya ok done it woooooooooooooooooooorks :D
really thnx bro
i have more Questions bs i dont wont to put u in stack with me :D
thanksssssssssssss

 

[Phildaburn]

You're welcome. Feel free to post additional questions when you need to.

 

[Joe4]

Just an FYI for future reference:

If you have brand new questions, it is best to start them in a new thread.

The general rule of thumb is if it is a clarification, follow-up, or "bump", post it back to the original thread (do not start a new thread as threads of a duplicate nature are generally locked or deleted). If it is a new question, start a new thread.

 

[do0ot]

plz can edit this code that will show for "IN*" and "VI*" Free

Fees: IIf([userid] Like "IN*","FREE",IIf(DateDiff("h",[Arrival],[Leave])>=1,"RO" & DateDiff("h",[arrival],[leave])*1,"FREE"))

 

[Phildaburn]

Fees: IIf(left([userid],2) in("IN","VI"),"FREE",IIf(DateDiff("h",[Arrival],[Leave])>=1,"RO" & DateDiff("h",[arrival],[leave])*1,"FREE"))

There you go.