Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS Access 2003 & Time Query
Name: Mark.UK Date: August 16, 2006 at 15:10:11 Pacific OS: XP Pro CPU/Ram: 2.8HT/1Gb
Comment:
I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time ([EndTime]-[StartTime])*24 which gives me the difference. From the result of this query I have created another query to display the SUM of the time difference.
The problem is I cannot get the answer to display in the Time Format as there is no Time Format Option in the properties, others but not time.
Q. Is there a way to get the result to display in the Time Format I require using Access 2003, a work around will do.
Summary: Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employees. One of the fields on this table is BLOB field...
Summary: I've got a question about SQL query in MS Access, for example I have the following data: Table1: NAME ______ CITY ____ FAV vahid ______ NY ______ A vahid ______ NY ______ B hamed ______ LA ______ A ha...
Summary: I'm trying a small database program using MS Access 2003. I have a number of tables ( 5 in number ) as one side related to a single table as a many side. This means the many side table has 5 foreign k...
0 
