date query Access 2000

[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

 

[Jeff Boyce]

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>

 

[Rob]

I am using Access 2000