I wasn't really sure where to put this so I put it in the most general section.
I have a set of queries to produce a couple of reports to excel (not access reports) that are all fairly complicated. The easy way to explain is that I have a union of 6 cross tabs that are based on summaries of unions (in some cases) that are based on further unions. Just trying to explain it makes my head hurt a bit.
The reason for this somewhat complicated structure is that the base data is as generic as required, and each level gets more specific and aggregates the level below. This is also complicated because the systems it is reporting on all do things slightly differently so each of the 3 systems have their own base queries that are all similar.
I am not sure I am explaining this really well but my request has to do with that failing. How do people document complicated query hierarchies? I have tried to do this in word and excel so far, and well while I can see which query feeds which, it seems to lose something in the translation no matter what I do. The thing is, it is starting to get so complicated that even I am getting confused about which data set is feeding which particular number. If I am confused, anyone else would most likely be hopelessly lost despite my somewhat rigid naming conventions.
Thanks for any help or advice anyone can give.