cheuschober
Muse of Fire
- Local time
- Today, 18:57
- Joined
- Oct 25, 2004
- Messages
- 168
Alrighty I have spent the last two days picking my brain and searching the posts for this one and I'm just downright stumped so I thought I'd turn to some folks who actually KNOW a thing or two about access. 
So, I have an accounting database. In this database there is a table where the date, amount, expense code, and payee information is all recorded.
I'm attempting to create a detail report based on an expense code.
What I would LIKE to do (keeping in mind that I'm not always IN my right mind about what can and can't be done!) is be prompted at the running of the report to enter a valid Expense code (which I'm assuming I can do by parameter query).
The information to be displayed on the report is a variety of totals and averages for that expense code based upon date information:
Current Year : Total | Last Year: Total
Last 3 Years: Total | Average / year
All Years: Total | Average / year
As for the actual DETAIL information, the only records I would like to be listed are the respective payees with this year's totals as well as a grand total for all years and an average / year.
I won't say I've tried EVERY combination of query preparation and domain aggregate functions since clearly I haven't tried the one that works but I've found myself running in circles.
If anyone has a suggestion as to how to set the system up to provide these results I'd be EXTREMELY appreciative! Thank you all so much!
Oh, and to those celebrating...
Happy All-Hallows Eve!!!
~Chad ::BOO::
So, I have an accounting database. In this database there is a table where the date, amount, expense code, and payee information is all recorded.
I'm attempting to create a detail report based on an expense code.
What I would LIKE to do (keeping in mind that I'm not always IN my right mind about what can and can't be done!) is be prompted at the running of the report to enter a valid Expense code (which I'm assuming I can do by parameter query).
The information to be displayed on the report is a variety of totals and averages for that expense code based upon date information:
Current Year : Total | Last Year: Total
Last 3 Years: Total | Average / year
All Years: Total | Average / year
As for the actual DETAIL information, the only records I would like to be listed are the respective payees with this year's totals as well as a grand total for all years and an average / year.
I won't say I've tried EVERY combination of query preparation and domain aggregate functions since clearly I haven't tried the one that works but I've found myself running in circles.
If anyone has a suggestion as to how to set the system up to provide these results I'd be EXTREMELY appreciative! Thank you all so much!
Oh, and to those celebrating...
Happy All-Hallows Eve!!!
~Chad ::BOO::
