Imran,

Given that you're a novice and haven't posted much here before, it's a good idea that you read Jeff Moden's article Forum Etiquette: How to post data/code on a forum...

If you specify the...

Please don't cross-post. I think this is a better place for your original question, which is here:

http://www.sqlservercentral.com/Forums/Topic1696469-150-1.aspx#bm1696655

If you post the same question in several forums, responses are harder to...

This parameter limits the data specific to IT related costs which is correct but I want to see IT costs that appear on an invoice which may have costs other...

I suppose you could, but the downside to doing it in SSRS is that you pull back a bigger dataset, and T-SQL will run circles around SSRS doing this any...

How about this one[/url]?

The part you want is at the end of the article.

I would probably see if HappyCat59 knows.

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...