Hey all,
I have these reports that generate the number of books that were borrowed from a library on a daily, weekly, monthly, and yearly basis. I have switchboard that has these command buttons on it (daily, weekly, monthly, and yearly), when u click on daily, a dialog box appears asking the user to select the date picker, then click go to preview how many books were loaned that day.
The others are a bit straining. For the weekly one I was considering creating a new dialog box with 2 date pickers for the start of the week and the end of the week. The thing is, the report is based on a query with the week format - Week: Format([DateBorrowed],"ww"). So the week appears like 01 or 02... no dates indicating the start or end of the week, which can be confusing.
The monthly query is quite similar to this with the format showing up like 01, 02, 03. I have a dialog box with two date pickers already on it with the start date and end date, but it still shows all the months. So that's my problem.
Any suggestions?
Lisa
I have these reports that generate the number of books that were borrowed from a library on a daily, weekly, monthly, and yearly basis. I have switchboard that has these command buttons on it (daily, weekly, monthly, and yearly), when u click on daily, a dialog box appears asking the user to select the date picker, then click go to preview how many books were loaned that day.
The others are a bit straining. For the weekly one I was considering creating a new dialog box with 2 date pickers for the start of the week and the end of the week. The thing is, the report is based on a query with the week format - Week: Format([DateBorrowed],"ww"). So the week appears like 01 or 02... no dates indicating the start or end of the week, which can be confusing.
The monthly query is quite similar to this with the format showing up like 01, 02, 03. I have a dialog box with two date pickers already on it with the start date and end date, but it still shows all the months. So that's my problem.
Any suggestions?
Lisa