date manipulation

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I've got a calculated date field that I would like to
include in a report, so I'm wondering if anyone knows how
to build the following as an expression, hopefully that I
can include in the query...

I need to have the query schedule manufactured homes to be
built by date based on building 5 homes per day with
weekends and holidays excluded. I also need the query to
tell me dates of when a house is scheduled to be started
and dates of when it is to be completed.

My database currently has 100 houses to schedule in it
and it is based on scheduling houses from an inputted
date range.

The fields I am trying to fill are OnlineDate and
OfflineDate. Online Date refers to the day a house is
started and Offline Date refers to the day a house is
completed. Online and offline dates are based on
completing 5 homes per day.

Does anyone have any pointers or suggestions?
 
There are a variety of built-in functions to assist with Date calcuations.
DateAdd(), DateDiff(), etc.

Try using those, and feel free to ask any specific question about their use.
After reading the help file, that is.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top