Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rcplanecrasher1

    Reporting on NULL values (DateTime included)

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

    Reporting on NULL values (DateTime included)

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

    Reporting on NULL values (DateTime included)

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

Part and Inventory Search

Back
Top