From & to dates

[Guest]

Please help! I have been asked to develop a database for an after school
club> the club has several rooms with varying activities. I need to have a
limited amount of children in each room due to adult, child ratios. Is there
a way I can input a start date and end date to show when a child is too old
for a room and has to move to an older aged room. I need to populate fields
from Monday to Friday and don't want to have to input dates every day. I am
hoping that the from and to dates will populate the inbetween dates in a
report or query??

Also is there a way to have a list box or combo box that an end user can
populate and the data will be automatically added to the list?

I am quite new to Access so please don't baffle me with science etc

Thanks in advance

Landor

 

[Dean]

create one table for rooms with 3 fields, room number, minimum age and
maximum age
create another table for the kids, with fields for name and birthday
create another table for Room Assignments with Lookup field that links to
the Room table and another field that links to Kids table, create a form
from this table using the wizard, this form will be used to assign kids to a
room, you will be able to pick a room and then assign one or more kids to
the room

create a query using all 3 tables joined together and set the criteria so
that the birthday is > Room Min Age and < Room Max Age to see who can be in
room, create additional similar queries to see who is not allowed to be in
room.

HTH
Dean

 

[Guest]

Works a treat!

Many thanks

create one table for rooms with 3 fields, room number, minimum age and
maximum age
create another table for the kids, with fields for name and birthday
create another table for Room Assignments with Lookup field that links to
the Room table and another field that links to Kids table, create a form
from this table using the wizard, this form will be used to assign kids to a
room, you will be able to pick a room and then assign one or more kids to
the room

create a query using all 3 tables joined together and set the criteria so
that the birthday is > Room Min Age and < Room Max Age to see who can be in
room, create additional similar queries to see who is not allowed to be in
room.

HTH
Dean