date query Access 2000

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I am setting up an automated production scheduler and
I am having a hard time with assigning online (start)
date and an offline (complete) date for a manufactured
housing company.

I have the following fields set up:

PRO# Confirm_Date Customer Model# Serial# #Floors

My routine prompts the user to enter the PRO numbers they
want to schedule, as well as the production rate (number
of floors built per day) in a query. Based on the input,
I need to calculate a start date and an end date for each
PRO number that needs to be scheduled. For the date
assignments, I want to screen out weekends and holidays.

Can someone give me some input?

thanks for the help! Rob
 
Rob

You don't mention which version of Access you are using. There is a
NETWORKDAYS function mentioned in Access HELP. You may need to establish a
reference to EXCEL to use a worksheet function.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top