Schedule Report

[ictcrystal]

Hello




Im trying to create a report for 4 dentists appointment schedule showing : Appointment time , customer ID, forname, surname and dentist room...


I want it to be on one report that has these details for each dentist on 4 seperate pages ( so one page for each dentist ) but im not sure how to go about this..


Any advice would be super! thank you

P.s. i have posted this Q in another forum but thought i would also post here for more advice as i usually work with answers when i get a variety

[ranman256]

Your query would pull the data for the 4 for the 1 day.
the rpt would sort on
Dentist
day
time

page break on Dentist.

[ictcrystal]

is it possible to give more detail please? sorry its just ive only ever made 1 report before which didnt really work out as expected. thank you

[ranman256]

Make a query that has all the data needed.
use a report wizard using that query to build it,
then click the sorting button to set the order of data.
Last...add a page break from the toolbar onto the report at the dentist footer.