Report creation

[ICTkirsten]

Hi,

Im trying to make a report which shows a timetable of a dentists.. ive made a query and created the report but i dont really know what i need to do to achieve the following:

Group by Dentist name
Times for each dentist should display the earliest first..


tHANKS

 

[GinaWhipp]

While the Report is in Design View right mouse click and select *Sorting and Grouping* from the tail. Then for Group By select the Dentists name or their ID. Make sure you select to show the Header and put the Dentists name there. And for Sorting select the field that holds the Time.