Search results

I recently upgraded to office 2007 as much as i didn't want to. I put a google desktop gadget that creates shortcuts to microsoft office products. Now with Office 2007 I can't find the actual application icons. I know it installs itself in both program files and program files(x86). Does anyone...

I have had similar problems with the append query feature. What seems to solve it is pretty much already mentioned. One of the best things to learn and get into the habit of doing with access is instead of naming ANYTHING (this includes table/query names as well as field name) with no spaces...

I have a similar problem. I am using the DateDiff function. The value is returning a decimal but not the decimal places. If someone worked 8 hrs and 30 minutes, i get 8.00 as the return value.Yes I've checked everything in the query to make sure the format is set to standard with the necessary...

I have an opposite question. I am doing a clockin/clockout for my work and when i run the difference in times such as TimeIn: 10:30AM TimeOut: 06:30PM. I am running a field in a query where its syntax is Hours: DateDiff("h",[TimeIn],[TimeOut]). I know the "h" displays hours but i don' know the...

My question is I am running a query for calculating clock in and out times for employees and want it to display as a decimal instead of a single integer using a query and not in visual basic. Like if clockin time is 10:00AM and clockout time is 06:30PM what would the query header be for the...