Access database question

[Steve]

I need some help with the following database designed to
schedule houses to be built based in a production
facility.

I have an access database setup with the following fields:

PRO#, Retailer, Customer Name, Model#, #of floors

I need to have this database automatically schedule
houses to be built based on number of floors built per
day. If I am scheduled to build 5 floors/day, I need a
report showing what houses will get built when.

If I have 200 floors waiting to be built, I need to have
the database give me a daily schedule with dates in a
report format. I also need the report to tell me the
date of when the house will be completed based on a 7 day
construction time.

Is this possible? If so, what is the suggested method?

 

[Steve Schapel]

Steve,

How do you decide which house gets built on which day? Is it in
strict sequence of project, and one project proceeds to completion
before another one starts? If so, how do you determine which one is
first, as there does not appear to be a ContractDate or some such
anywhere? What is PRO?

By the way, it is not a good idea to use a # as part of a field name.

- Steve Schapel, Microsoft Access MVP

 

[[MVP] S. Clark]

You're looking at an entire custom application, which means forms, queries,
and VBA code.

--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-