Tamakm
Last Activity: Aug 21 '13, 01:48 PM
Joined: Jul 4 '13
Location:
-
Thank you for taking time to respond. I was really looking for help and understanding to write the code.... -
Sorry, Didn't realised it. This is what you are looking to check?.
...Code:SELECT ([EqualizationToApproveAdvOT_1].[OT-StartTime] >=[EqualizationToApproveAdvOT].[OT-EndTime]) Or ([EqualizationToApproveAdvOT_1].[OT-EndTime] <=[EqualizationToApproveAdvOT].[OT-StartTime]) Or ([EqualizationToApproveAdvOT].[OfficersName] <>[EqualizationToApproveAdvOT_1].[OfficersName])Last edited by zmbd; Aug 13 '13, 11:44 AM. Reason: [z{Removed unneeded list tags}{stepped SQL for better read}]Leave a comment:
-
Top box in my reply is with SQL statement in my Query
and I am using that query in the report.
Not using other SQL cmmand for this. I have attached the table, Query and form....Leave a comment:
-
CompletePicture of database
SQL below is in Access Query and Report is based on query which is run by function in the form command button.
...Code:NoOTClash:([EqualizationToApproveAdvOT_1].[OT-StartTime]>=[EqualizationToApproveAdvOT].[OT-EndTime]) Or ([EqualizationToApproveAdvOT_1].[OT-EndTime]<=[EqualizationToApproveAdvOT].[OT-StartTime]) Or ([EqualizationToApproveAdvOT].[OfficersName]<>[EqualizationToApproveAdvOT_1].[OfficersName])
Leave a comment:
-
Apologize for posting code improperly. Actually, I have the query with the code listed previously With two copies of the table in that query. Than I created a report based on this query. and than created a form and added command button with the code below. But since I am not entering Date, StartTime, EndTime (Because this is already listed in the table. I just add a location for employee as I am approving the overtime. This code is not working. ...Last edited by zmbd; Jul 7 '13, 06:06 AM. Reason: [Tamakm;{Try to add line Number}] [z{removed un-needed formating within the code block and reformatted}{the code block keeps collapsing... arrgh]Leave a comment:
-
I am not a programmer.
Like access and create simple databases.
I have this code in my query which I found on line.
I have added this code in my query.
I created a report from this query and added the report in form command button to give alert that there is a conflict.
Soon I add location each and every approval that message comes up because all employees have signed up for overlapping...Last edited by zmbd; Jul 6 '13, 07:23 PM. Reason: [Z{Please use the [CODE/] formatting button to format your posted code and SQL}{Stepped what appears to be calculated field for easier reading}][z{second edit... added white space to posting to ease tLeave a comment:
-
Conflicting time for work schedule
Hello,
I have the ms access database which I use to assign overtime to employee.
One tbl One 'Overtime Lines' Fields: Line No, Date, Start Time, End Time.
Tbl Two 'Employee List' Fields: Employee name, Emp ID, Seniority No.
Tbl three 'Overtime Signups Employee Name, Overtime Line number, Qualifications’ , Location
Employee signup a week in advance by selecting overtime line number on...
No activity results to display
Leave a comment: