Creating A report

[ICTkirsten]

Hi,

I am trying to create a report for 5 different dentists schedule for their current date ( and also allow a search for upcoming appointments)...

i know it requires a query but im not to sure what direction to take as i have never created a report before...

What needs to appear on the query? im aware it would be all the fields i want on the report but do i need to make changes in the critiera etc..

I also dont really know how i can create a report for each dentist because i dont want to have 5 different reports.. is it possible to have the report set where i type the dentist name and select which one i require and then i can view their schedule?

Please may i be advised

thank you very much

 

[plog]

You can use VBA to apply criteria to a report itself when you open it. So what I do in situations like this is create 3 objects--a query, a report and a form.

The query is as generic and inclusive as possible. The only criteria I use on it, are criteria that I would want implemented everytime. You said you only want today and upcoming appointments, I would use that in the query criteria (>=Date())

My report would be grouped appropriately, putting a page break element in the main grouping footer. You report sounds like you want to group this primarily by doctor. I would create a doctor grouping and put a page break in the footer. That way it comes out as a series of pages, each doctor on a new one.

My form would control the criteria that could change. For example if you wanted to run just one doctor i would put a drop down on the form with all the doctors, I might even put 2 inputs so the user could input specific time frames. Then at the bottom of the form a button that when clicked runs VBA which looks at all the input criteria on the form, creates a criteria string and passes it to the report via the DoCmd.OpenReport method.