Adding lines to report

[Del]

I have a database which is used to keep track of blood donations /
scheduling. I have created a report that will show all the donors that
have signed up for a specific date and time. The report works fine,
but the user has requested one addition to the report and I can't
figure out how to do it. There are specific time slots and a specific
number of donors allowed to be scheduled for that time slot to be
schedule through out the day. The available times and number of slots
per time are as follows;

9:00AM - 3 Donors
9:15AM - 2 Donors
9:30AM - 2 Donors
9:45AM - 2 Donors
10:00AM - 2 Donors
10:15AM - 2 Donors
10:30AM - 2 Donors
10:45AM - 2 Donors
11:00AM - 2 Donors
11:15AM - 1 Donor
11:30AM - 1 Donor
11:45AM - 1 Donor
12:00PM - 1 Donor
12:15PM - 1 Donor
12:30PM - 1 Donor
12:45PM - 1 Donor
1:00PM - 2 Donors
1:15PM - 2 Donors
1:30PM - 2 Donors
1:45PM - 1 Donor

The request is to have the report add blank lines if the allowable
donors for that time slot have not been scheduled. This would allow
for walk-ins to fill the unused slots. (Example: For the time slot of
9:00AM three donors can be scheduled. But only two have been
scheduled. The user would like Blank Lines for the third spot. For
9:15 AM both available donors have been scheduled so no blank lines
would be printed in that time slot. At 9:30 AM no one has signed up so
there would be two sets of line entered. See sample below....

Sample Report:

Schedule Time Donor Phone Ext. Donated Signature
9:00 AM
John Doe 1111 ___
___________________
Jane Smith 1234 ___
___________________
_______________ ____ ___
___________________

9:15 AM
Donor Name Ext. ___
___________________
Another Donor Ext ___
___________________

9:30 AM
_______________ ____ ___
___________________
_______________ ____ ___
___________________

Thanks for any help !!!

Del

 

[Chris Sergent]

Del,
With the form that is being used, maintain a count for
each day while data entry is being done by using
IsNotNull. If any of the given fields have maxed out.
This would be a complete form of the daily schedule and
each new form would be a new day.

Second,
Ensure there is a date on the form and then create an
append query: Evaluate which records time frames still
have openings using a count function. If they are below
the maximum and they are null append the date field. This
way you will have the date already entered as well as an
opening in the database to enter the new records.

When the report prints, it will have the information as
well as the extra empty lines.
Chris
sergent7//@earthlink.net
No Slashes.

 

[Del]

Del,
With the form that is being used, maintain a count for
each day while data entry is being done by using
IsNotNull. If any of the given fields have maxed out.
This would be a complete form of the daily schedule and
each new form would be a new day.

Second,
Ensure there is a date on the form and then create an
append query: Evaluate which records time frames still
have openings using a count function. If they are below
the maximum and they are null append the date field. This
way you will have the date already entered as well as an
opening in the database to enter the new records.

When the report prints, it will have the information as
well as the extra empty lines.
Chris
sergent7//@earthlink.net
No Slashes.

Thanks Chris,
I'll give it a try...