DataBase Design.

[cap.zadi]

Dear, I hope there will be some one to help out for this datababse design.



I have the following table and description.

tblKilnInfo
TrnNo PK (Autonumber)
TrnDate Date/Time
ShiftID Combobox
KilnNo Number
KCarID Number
PushingTime Number
Intime Time
OuTime Time
Note Text



There is every day in each shift Kiln Cars (KCarID) which goes in and some of goes out.

so after this data entry, i will be required to know that if the KCarID 89 enter at 08:00AM on dated 09/21/2011 and it was out at 17:00 09/24/2011. so will be required to know for ho many days/hours this car been inside the kiln and so on.

please advise?

tble fields and settings?
Query to retrieve the data?


thanks.

zahid

[TheShabz]

DateDiff ( interval, date1, date2,)

http://www.techonthenet.com/access/f...e/datediff.php

[cap.zadi]

Thanks Sir, it is a useful link. But i am looking to manage the TrnDate and Intime and Outime together.

Like we made Tran dated on 09/20/2011 and car # 01 Intime was 10:00 Am so dated on 09/22/2011 there was an Tran in which this car # 01 OutTime was 21:00 PM So what will be the query to retrieve the data that will shows that this car # 01 hopw many days or hours passed inside Kiln.

please advise.

thanks.

zee

[TheShabz]

The datediff function is how it's queried
SELECT CARID, DateDiff ( interval, date1, date2,)
FROM wherever