Hey thanks again for the time and help missinglinq but I found a different way around the isssues by using IIF statements in the query.
Have a good one!
Adam1331
Last Activity: Aug 14 '08, 02:02 PM
Joined: Jul 18 '08
Location:
-
Ok, so I tried putting this in
=DSum("DateDiff ("n",[StartTime],[EndTime]","TimesheetQue ry","[ProcessNumber] >= 3000 And [ProcessNumber]<= 3500")
and received the error
The expression you entered contains invalid syntax
You may have entered an operand without an operator
Any advice?Leave a comment:
-
DSum Issues
I've been trying to get the DSum function to work but I've been running into some roadblocks. What I'm trying to do is to total up times in a timesheet report into different departments. The report is based on a query that gathers all an employee's info. In that query, I have a calculated field which gives an employee's total time on a process.
(DateDiff("n",[StartTime],[EndTime]))/60
This gives the total... -
Thanks again for your help. I think I have it figured out. After my last post I created a macro (which I haven't done before) using the SetValue and linked it to a command button on a form that pulls the records from a query. This way I can use just one table and still use the [Now()] function. If you can forsee any problems with this let me know, otherwise thanks again for your time and help.Leave a comment:
-
This doesn't seem to work for my database or my lack of experience prevents me from being able to make it work. I do have another direction I could take things if you could help me with a different problem.
Originally there were two forms. One was a [Check In Form] which recorded the information to the [In Table]. The other was a [Check Out Form] based on a query that was run on the [In Table]. The problem with this was that I couldn't...Leave a comment:
-
And actually if I could input a No Duplicates rule I could just sort the times as ascending and that would solve the issue as well.
Thanks again for your helpLeave a comment:
-
Puppydogbuddy-
Using the MinStart time and MaxEnd time function works great but the problem is that it doesn't account for the time the employee was on break. So now it will calculate just one time, 11:30-1:00 and omit the 12:00 clock out time and the 12:30 clock in time. Now it comes up with a total time of 1.5 hours on the job instead of 1 hour.
I also played with the Sum function a little seeing that the Sum of...Leave a comment:
-
Calculating Time
I am currently setting up a database for work that will operate as a timesheet. I have set up multiple tables, queries, forms and reports to help this process run smoothly.
The issue that has come up deals with calculating our times. An employee would use one form based on one table to punch into a job and the time is recorded using the value [=Now()] and then will punch out of a job on a seperate form based on a seperate table which...
No activity results to display
Leave a comment: