Bonifaceg
Registered User.
- Local time
- Today, 06:58
- Joined
- Oct 26, 2004
- Messages
- 18
Hello All.
I am in need of some help for an Access database with the following tables:
Bunklist (1-100)
ClientInfo
ClientStayInfo
ClientChoreInfo
Occurrences
The above will be for a Shelter housing up to 100 men (Clients). Each client already has a file with his details (Table ClientInfo). Clients are allowed to stay at the shelter for a period of 90 days every year (Beginning on date of first Check-in). Clients have to perform a chore(s) for their stay. (The chores are assigned an hourly value). The client's hourly chore total should be equal to / greater than the days stayed, or they lose their bunk. Clients have to "check-in" daily by 8:00 PM or they lose their bunks.
My Issues:
1) To have a dynamic list for the Bunks available for assignment to a client. (Eg. After I assign Bunk 35, it should be removed from the list of available bunks, for subsequent Bunk Assignments).
2) To Automatically Free up bunks whose clients have not checked-in by 8:00 PM, unless the client put in for a late Check-In.
3) To calculate the hourly-chore value to date (Total, and cummulatively by date)
4) To free up the bunk once the client checks-out or is asked to leave for any reason.
5) To calculate the number of days stayed over the last 365 days
6) DETAILS:
# Not able to create a sub-form within the ClientInfo Form showing Client's history.
# Not able to calculate the expected check-out date in the ClientStayInfo table using the CheckIn date. (Does this have to be manually put in? The expression generator has no tables listed).
# To save the ClientStayInfo table as different tables with today's date, each day. (This is done for archives & reports by date. Any suggestions would begreatly appreciated).
# For quick Check-in, an interface where all the bunk-numbers and associated clients (Whose time is not yet up) are listed for "One-Click" Check-ins.
Any & all help will be greatly appreciated.
Regards, & Thx.
I am in need of some help for an Access database with the following tables:
Bunklist (1-100)
ClientInfo
ClientStayInfo
ClientChoreInfo
Occurrences
The above will be for a Shelter housing up to 100 men (Clients). Each client already has a file with his details (Table ClientInfo). Clients are allowed to stay at the shelter for a period of 90 days every year (Beginning on date of first Check-in). Clients have to perform a chore(s) for their stay. (The chores are assigned an hourly value). The client's hourly chore total should be equal to / greater than the days stayed, or they lose their bunk. Clients have to "check-in" daily by 8:00 PM or they lose their bunks.
My Issues:
1) To have a dynamic list for the Bunks available for assignment to a client. (Eg. After I assign Bunk 35, it should be removed from the list of available bunks, for subsequent Bunk Assignments).
2) To Automatically Free up bunks whose clients have not checked-in by 8:00 PM, unless the client put in for a late Check-In.
3) To calculate the hourly-chore value to date (Total, and cummulatively by date)
4) To free up the bunk once the client checks-out or is asked to leave for any reason.
5) To calculate the number of days stayed over the last 365 days
6) DETAILS:
# Not able to create a sub-form within the ClientInfo Form showing Client's history.
# Not able to calculate the expected check-out date in the ClientStayInfo table using the CheckIn date. (Does this have to be manually put in? The expression generator has no tables listed).
# To save the ClientStayInfo table as different tables with today's date, each day. (This is done for archives & reports by date. Any suggestions would begreatly appreciated).
# For quick Check-in, an interface where all the bunk-numbers and associated clients (Whose time is not yet up) are listed for "One-Click" Check-ins.
Any & all help will be greatly appreciated.
Regards, & Thx.
