Thnx a lot for this tutorial. Sorry for my delayed response as was out of town where network was poor. It helped me a lot in building my report successfully and it is working perfect. Incidentally my form is a tabular form having multiple rows against each team. I just wanted to build a report which will show the name, Team number and the total score (subtotals against each team, learnt from your tutorial). So if there are ten teams, the report will consist of 10 rows. But as the database or table has 18 rows against each team, it collects all the 18 rows and creates a large gap between two sets of records. I tried with hide duplicates. With that duplicates are hidden But the space gap remains. Created new table But problem still persists. Tried with teamwise grouping but cannot get out of it. As I never experienced such problem earlier, this is just for your kind information. Regards.
Now that you have the calculated subtotals you want added to each record you can put all of the fields you want in the report in either the group header or group footer section which prints only once for each group (in your case, once for each team). Close up the Detail section altogether which prints once for each record. You don't need it for what you are trying to accomplish. That will eliminate the duplicates problem.
Thanks for the heads up. The course names have changed to CSS 114 catalog.jccc.edu/search/?search=css+114 and CSS 115 catalog.jccc.edu/search/?search=css+115. I will update the links.
Is it possible to make a data entry form for multiple tables or a form from a query? For instance, can you make a form for a new customer and their orders in the same form to update different tables?
Yes and yes. I always like to create a query with all of the fields I need before starting the form wizard just because I think that makes it easier to maintain the form later and I think it improves performance too. Use the Form Wizard and select the query you created. The Form Wizard will recognize that one customer can have many orders and will put the orders fields in a subform. There is a good example of this in the Northwind sample database, frmCustomerDetail.
Amazing Job Prof.
Thank You.
Ty! All of my UA-cams are organized at learncs.w3spaces.com
Wow.
Thank You Again.@@lfriedrichsen
Thnx a lot for this tutorial. Sorry for my delayed response as was out of town where network was poor. It helped me a lot in building my report successfully and it is working perfect.
Incidentally my form is a tabular form having multiple rows against each team. I just wanted to build a report which will show the name, Team number and the total score (subtotals against each team, learnt from your tutorial). So if there are ten teams, the report will consist of 10 rows. But as the database or table has 18 rows against each team, it collects all the 18 rows and creates a large gap between two sets of records. I tried with hide duplicates. With that duplicates are hidden But the space gap remains. Created new table But problem still persists. Tried with teamwise grouping but cannot get out of it. As I never experienced such problem earlier, this is just for your kind information. Regards.
Now that you have the calculated subtotals you want added to each record you can put all of the fields you want in the report in either the group header or group footer section which prints only once for each group (in your case, once for each team). Close up the Detail section altogether which prints once for each record. You don't need it for what you are trying to accomplish. That will eliminate the duplicates problem.
Hi Lisa, I noticed your links no longer works for the Access courses at CPCA 114community college and 115. Are they no longer offered?
Thanks for the heads up. The course names have changed to CSS 114
catalog.jccc.edu/search/?search=css+114 and CSS 115 catalog.jccc.edu/search/?search=css+115. I will update the links.
Is it possible to make a data entry form for multiple tables or a form from a query? For instance, can you make a form for a new customer and their orders in the same form to update different tables?
Yes and yes. I always like to create a query with all of the fields I need before starting the form wizard just because I think that makes it easier to maintain the form later and I think it improves performance too. Use the Form Wizard and select the query you created. The Form Wizard will recognize that one customer can have many orders and will put the orders fields in a subform. There is a good example of this in the Northwind sample database, frmCustomerDetail.
See all of my UA-cams organized at learncs.w3spaces.com. I have short videos on these topics. :)
Thank you so much for your response and help!@@lfriedrichsen