Given the data, this works:

SELECT RecID

, BO_ID

, Code

, Code_Date

, MAX(CD1) AS Msg1

, MAX(CD2) AS Msg2

, MAX(CD3) AS Msg3

FROM

(SELECT 1380900 AS RecID

,'XZ01' AS BO_ID

, 12 AS Code

, '1/16/2015' AS Code_Date

, 'P302'...

Try this:

...

WHERE TT11.Period>=@BeginPeriod

AND TT11.Period<=@EndPeriod

Instead of

=iif( Fields!ColA.Value<>Fields!ColB,"Red","Green")

try

=iif( Fields!ColA.Value=Fields!ColB,"Green","Red")

CYA and make a backup and keep it in a safe place...

then offer to sell it to him later... No, just kidding about the last part.

Here's one I did based on the database provided by Itzik Ben-Gan in his book. It's the same kind of Customers/Orders/Line Items database. What I'm doing is showing all...

This will return all APInvoiceNum values that contain at least one IT-related expense.

SELECT APInvoiceNum AS Invoice

FROM GLJrnDt1

WHERE GlJrnDt1.SegValue BETWEEN '310100' AND '330500'

/* You may not need these extra filters here...

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