W
Will
I am using the database wizard for a reservations system for a charter
fishing boat.
The boat makes individual reservations which works fine, but they have an
overview page which shows the month at a glance. I am using a custom query
to show just the total booked on the boat on a given day.
SELECT Sum(Results.group_size) AS SumOfgroup_size
FROM Results
WHERE (((Results.month_of_trip)='May') AND ((Results.day_of_trip)='2') AND
((Results.ship)='challenger'));
Works fine except when the page is displayed there is a blank space for each
individual record and then the total is displayed. You can see it here
http://www.clipperfleet.com/reservations/bymonthmay.asp
Does anyone have a suggestion how not to have the blanks.
Thanks
Bill
fishing boat.
The boat makes individual reservations which works fine, but they have an
overview page which shows the month at a glance. I am using a custom query
to show just the total booked on the boat on a given day.
SELECT Sum(Results.group_size) AS SumOfgroup_size
FROM Results
WHERE (((Results.month_of_trip)='May') AND ((Results.day_of_trip)='2') AND
((Results.ship)='challenger'));
Works fine except when the page is displayed there is a blank space for each
individual record and then the total is displayed. You can see it here
http://www.clipperfleet.com/reservations/bymonthmay.asp
Does anyone have a suggestion how not to have the blanks.
Thanks
Bill