Before I get into possible solutions, if you're just starting on this database, I would advise you to reconsider your design. Basically you're storing more than one fact in...

I'm assuming you're using Access 2013 (it's what I have installed, sorry!) so if this doesn't work, you might need to specify the version of Access you're using.

If you're querying...

Maybe this?

https://gallery.technet.microsoft.com/scriptcenter/Get-List-of-Unused-SSRS-9091d7bb

Maybe something like this, assuming you're using 2008.

http://www.rafael-salas.com/2008/05/t-sql-lead-and-lag-functions.html

If the data comes from different tables, you have to union the two queries together.

SELECT...

FROM tableA

UNION [ALL]

SELECT ...

FROM tableB;

Why are the history records in another table? Did this come from...

Maybe this article[/url] will help.

Or maybe use this to get the average?

COUNT(Fields!enrollmentID.Value)/CountDistinct(Fields!EnrollMonth.Value)

I added it to a new column outside the normal matrix group

Please post consumable data -- in the form of CREATE TABLE/INSERT statements or a SELECT statement with UNIONS...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

mwill172 (6/11/2015)

---

Thanks for such a fast reply. I have very little knowledge in access and SQL, so please explain the following process 'Update with the value of the autonumber.' I...

Create another table of just the unique SSNs. Add an autonumber to the table. It will populate with unique numbers (might have gaps). Add another column to the...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cf06de2b-683b-4208-9682-a13f5e7ac2cd/help-with-mdx-query?forum=sqlanalysisservices

Orange is a running sum? If you're using 2012, use a windowing function to create the running total, then just base the report on your stored procedure.

Maybe you should read this. Most people don't want to download files from people they don't know...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I should have referred you to this article:

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

It explains how to post data etc. It just makes...

Can't do that anymore. Haven't used SSRS 2005 in a long time, and don't have it installed anywhere.

Where to begin? For starters, since you're clearly new here, it would help a LOT and you would get better answers if you posted sample data like this:

SELECT 2015AS...