Reports, Subreports, oh my

[Ms Kathy]

I do have a question. In looking at the Relationships I see 3 tables there that I can't seem to find anywhere else. They are named MSysNavPaneGroupCategories, MSysNavPaneGroups, and MSysNavPaneGroupToObjects. Can you tell me about these tables so I can better comprehend what you did? Thank you kindly.

 

[plog]

Those tables have nothing to do with what I did. They are Access systems tables and you can disregard them. However, if you want you can read about them here: http://answers.microsoft.com/en-us/...p/38096d43-0dff-4785-9eef-6a4ba88cf957?auth=1

 

[Ms Kathy]

I feel better now because I couldn't see their purpose.
These queries are quite amazing. I didn't realize you could work with them like this - query from a query, linking queries, and creating another. Where can I go for more education on that?

 

[plog]

Just practice really. They key is realizing that you don't have to do it all in one query because you can build queries on top of queries. Once you realize that it becomes easier to break your problems down into manageable parts and work on them part by part.

 

[Ms Kathy]

You got me thinking outside the box.

 

[Ms Kathy]

I have another question. Why are the links between all the queries using the Prod_Shift rather than the ID?

 

[plog]

Because that's how you wanted to report on your data; by shift not by ID.

 

[Ms Kathy]

Yes, yes, of course. I'm still struggling a bit as I try to comprehend. I'm thinking of other ways (parameters) of which we would use the report. But I should probably just make other queries for that huh?

 

[plog]

That's how it should work--You start with what you want to know and then create queries to deliver that.