By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

Designing a Summary Report entering multiple dates for multiple criteria

P: 13
I have to create a summary report that will provide counts and # average of days for multiple "Status" by entering different dates for every criteria. I have created several queries that calculates the number of days and the counts. I have created the corresponding report to show the sum and verages. But I don't know how to make them print on a main report that will display the information of multiple status since I have to enter multiple dates. I have to be able to pull the report form a the main form. Is there a way to build this from the form?
For instance I want to find the number of student who went into schedule during a time frame and the average number of days between the new status and schedule status. then I want to do similar to sutdent who were on new status and drop out.and so on. these would have to be all in one report.
Any suggestions will be apreciated.
Oct 19 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Create subReports for each of the different queries. Then put the sub report controls on the main form.



I have to create a summary report that will provide counts and # average of days for multiple "Status" by entering different dates for every criteria. I have created several queries that calculates the number of days and the counts. I have created the corresponding report to show the sum and verages. But I don't know how to make them print on a main report that will display the information of multiple status since I have to enter multiple dates. I have to be able to pull the report form a the main form. Is there a way to build this from the form?
For instance I want to find the number of student who went into schedule during a time frame and the average number of days between the new status and schedule status. then I want to do similar to sutdent who were on new status and drop out.and so on. these would have to be all in one report.
Any suggestions will be apreciated.
Oct 20 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.