Report

[ictcrystal]

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


ps I have posted this question on another forum but have not received any replies

[JoeM]

Create an Aggregate Query.

To do this, simply create a new query and add the Dentist name and time field to the query (and nothing else).
Then, click on the Totals button (looks like a Sigma).
This will add a Totals row under each field.
Leave the phrase "Group By" under the Dentist name field.
Change the phrase to "Min" under the time field.
View the results. It should have what you want.
So then use this query as the basis of your report (or join it in another query if you want other fields too).