Need help with Relationship Diagram
Hello! 😃 I'm very new to Microsoft Access and I'm trying to build a system for my small school to help keep track of all our student's monthly course registration and payments. Can somebody point out any mistakes or improvements that I can make to this Relationship diagram please? I'm at my wits end lol I would really appreciate any help! Cheers, Ben
PivotTable : Unexpected behavior with 2 tables
Hi, The first picture shows the expected behavior of adding 'Product' and 'Revenue' to a pivot table. Now when i add the same fields but from 2 different tables linked with a relationship, the result is different (please see 2nd picture). Could somebody explain this weird behavior ? Thanks in advance PivotTable with 1 table PivotTable with 2 tables Relationship
