Search results

Getting Much closer. I used a module I found in a previous thread which defines weekdays. When I run the following it counts the days excluding weekends. That's Great! DaysWorked: Weekdays([Date_Received],[Date_Complete]) The other thing I need is a "Due Date" which is 2 days after the...

I have a date feild called "Date_Received" and another called "Date_Complete". I need the DateDiff to be the total number of days excluding weekends. Does this need to be done in code, a module, or a query expression?

I need to send a notice to individuals whose due date is 3 days past due. This date is working days only. Is there a way to set-up the dates for weekdays only?

I am attempting to update a record in a table by using an update query. This works perfectly when I run the query, but when I attempt to run the query using an action button on a form, I am having trouble. The record is updated, but at the same time it is adding a new record. Any idea why...

Got it! Thanks:D

I still need to know how to set the date feilds to null. Thanks for your quick reply.

I have two feilds in my form "Current_Step" and "Next_Step". The "Next_Step" is a combo feild. I would like to choose the "Next_Step" then have a command button to update the "Current_Step". When "Current_Step" is updated, I also need to set two different date fields to Null. I was going to...