These expressions got me there:

=Lookup(Fields!ProjectNumber.Value, Fields!ProjectNumber.Value, Fields!MaxFailDate.Value,"MaxFailDate")

=IIF(ReportItems!MaxPassDate.Value > ReportItems!Due.Value, "Pass", IIF(ReportItems!MaxFailDate.Value > ReportItems!MaxPassDate.Value ,"Fail", "Due"))

To simplify, I think, I just need that query to result in the one row with the maximum FailDate as the result, not all of the rows as shown above.

I...

Ah yes, you have steered me in the right direction. The Actions value needs this filter: WHERE tblDataActions.Actions IN (@Actions)

Where and how would I place this filter so...

Will this just copy the node "Description"?
Thank you for your help.

It worked! Thanks man, you saved me a lot of time. I'm learning and promise to do better here.

Sorry,

This is clearer. The RefNo columns must macth.

https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

I need to make this update for a few hundred rows and I thought there might be a query so that...

Please check this image for example of what I mean:

https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

You are all geniuses, thank you!

Ooops, never mind last one, i figured it out!!

One new issue has popped up however, it is not bringing in data where the IssueDate is NULL

One more thing:

The report parameters allow me to choose multiple applications types and multiple status types.

If I select one of each it runs ok. If I select one application type...

I've been copying the code as created by SQL Report Builder. Thank you for the advice on formatting. I'm learning. 🙂

I'll plug you code in and let you know. Thank you (I'll try to get better at posting in the future).

I tried a variant of that but I did not have the () in the right places. Thank you, you're the best!

Based on Lowell's reply I came up with the following and it worked! I created a new table tblNumbersApplication with the columns Number and Label. Thank you!

SELECT tblDataPermit.Type,

tblNumbersApplication.Label

FROM tblDataPermit

LEFT JOIN...