Thank you all very much for your replies. You have confirmed for me what I had suspected. I need to have the privileges to the system tables if I am...

Ron - thank you for replying so soon. However, because I do not have access to the system tables the query does not work for me. Here is the error...

Thank you very much

this is the statement that worked for me:

=iif(Fields!ObsCatItemDecript.Value + Fields!DocValue.Value =" ",TRUE,FALSE)

thank you very much for clarifying this point. It is definetly one that I will remember.

Charles - Thank you very much. This is exactly what I was looking for.

Why are you using GUIDS? (answer: Because these are the keys that this particular vendor uses to join these particular tables)

Why are you using aliases to format display headers? (answer:...

I would like to see the datediff in ( minutes). I would like the results to be something like

mrn pain rating ...

Thank you Bob and everyone else problem solved.

Thanks Jack. This is a message that I get when I try to run a standard report that was developed by our software vendor. The report pulls the information from...