GOT it with the help from both of you. LB thank you for pointing out I was missing the if... and instead of a left outer join I needed a right outer... Thank you so much to the both of you..... I truely appreciate it.. I was going batty on this one... thanks again
thank that made no errors.. However it is not returning the test ticket I have created that does not have a journal entry. So none of those fields are populated with info. When I put the formula in the details section it still does not populate my test ticket...
I have the 2 tables linked... If...
I am trying to report on any tickets (that are grouped) that have no journal entries. And report back to the report that there is no info. My hangup is DateTime. In the SQL Table it reads <null> however when I write my formula it asks for a date time. Any help would be appreciated...This is what...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.