I have created a simple database for the school nurse at my school. I have a layout named Data Entry with approx. 100 checkbox fields. The nurse checks the box for symptoms, etc. I also have a layout called report that shows a count of all fields from Data Entry. What I'd like to do is give her the ability to enter a date to get a daily report, then at the end of the month, get a monthly report for a specific month. This newbie is having trouble figuring this one out. My date field is simply called date and is populated upon record creation. Any help you guys could give would be super. Thanks.

You can keep a search layout in your database and keep your date field on this layout and a Continue button. Create a script with the following steps:

allow error capture[on]

allow user abort[off]

Go to layout <>

enter find mode[pause]

perform find[]

if status[currenterror]=401;

show message [No records found matching your search criteria]

else

go to a report to show a count of all fields

end if

At this point she can enter a date on which she wants to search the database. If she wants to search for the month then she can enter 10/01/2005...10/31/2005. She can then click on the Continue button. On the continue button, call the script step "Pause/Resume Script"