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

 

[Phildaburn]

Fees: iif([userid] like "IN*","FREE",iif(datediff("h",[arrival time],[leave time])>1,"$1","Conditions not met"))

I've not tested this. Arrival time and leave time may need to be switched. You didn't say what needed to be done if the data doesn't meet the criteria you described, hence the "Conditions not met".

Phil...

 

[do0ot]

I've not tested this. Arrival time and leave time may need to be switched. You didn't say what needed to be done if the data doesn't meet the criteria you described, hence the "Conditions not met".

Phil...

first of all thnx bro for helping me
about the arrival time and leave time really i didnt get the concept can u help me more if u dont mind
for example my table is now like that

USERID Arrival LEave Fess
IN003 10:00:00 AM 12:00:00 AM Free
ST004 8:00:00 AM 10:00:00 AM 2 Dolar

IN=Refeer to instructor so the fees will be wrttin on it free
ST=refeer to student and he have park for 2 hours so the fees should be 2 Dolar

i really get confused on how doing that :S

 

[Phildaburn]

Fees: iif([userid] like "IN*","FREE",iif(datediff("h",[arrival time],[leave time])>=1,"$" & datediff("h",[arrival time],[leave time])*1,"Conditions not met"))

Thanks for providing more information. This expression will now calculate an hourly rate. What do you charge students who use your space for less than 1 hour?

 

[do0ot]

i will try it now
for less than i hour will be free

 

[Phildaburn]

Ok.

Fees: iif([userid] like "IN*","FREE",iif(datediff("h",[arrival time],[leave time])>=1,"$" & datediff("h",[arrival time],[leave time])*1,"FREE"))

This should do it for you then.

 

[do0ot]

ok bro its working but the problem is he asking my to enter the arrrival time and leaving time and i already entered this record befor so it have only to calculate it :D

 

[Phildaburn]

What are the exact field names where the arrival time and leaving time data is stored?

 

[do0ot]

frist feild Arrival and the second Leave
the record im typing it manually so just to have to calculate the hourse and than type the fees

 

[Phildaburn]

Fees: iif([userid] like "IN*","FREE",iif(datediff("h",[arrival],[leave])>=1,"$" & datediff("h",[arrival],[leave])*1,"FREE"))

Here it is using your field names. Give this one a try.