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!

Register Log in
  • Congratulations Chris Miller 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. Riverswan

    Null value - on one selection still needs to print

    SELECT resrooms.roomnum, res.guestname, res.groupcode, res.arrivedate, res.arrivetime, res.expdepartdate, res.vipcode, rescomments.commtype, res.status, rooms.hkstatus, res.hotelnum, rescomments.comments FROM dev:eci.res res, dev:eci.resrooms resrooms, dev:eci.rooms rooms, dev:eci.rescomments...
  2. Riverswan

    Null value - on one selection still needs to print

    Okay- I did do that and create a formula (with no errors) - however it is still not returning records that do not have a commenttype. so if that field is blank and the guest has one of the codes of V!, V2 or V3 it is not printing the information.
  3. Riverswan

    Null value - on one selection still needs to print

    if isnull{rescomments.commtype}or not({rescomments.commtype} in ["FO", "HK", "VIP"])then ""else{rescomments.comments} okay- it is now a formula; however still getting the same error. :(
  4. Riverswan

    Null value - on one selection still needs to print

    {res.arrivedate} in {?Begin Arrival Date } to {?End Arrival Date } and {res.status} <> "CXL" and {res.vipcode} in ["V1", "V2","V3"] and {res.hotelnum} = {?Hotel Number}and if isnull{rescomments.commtype}or not({rescomments.commtype} in ["FO", "HK", "VIP"])then ""else {rescomments.comments}...
  5. Riverswan

    Null value - on one selection still needs to print

    I have a VIP report to pull with comments. There is a vipcode field and a commenttype field. I need three different vipcodes and the comments from three different commenttypes; however even if the commenttype is null and the person has the vipcode I need that person to print on the report...

Part and Inventory Search

Back
Top