Assisi Software
  • HOME

    • BLOG
  • PRODUCTS

    • COMPILER
    • INVENTORY
    • MANAGER
    • ENTERPRISE
  • SUPPORT

    • FORUM
    • VERSION HISTORY
    • LIBRARY
  • ASSISI

    • ABOUT
    • CLIENTS
  • More

    Use tab to navigate through the menu items.
    To see this working, head to your live site.
    • All Posts
    • My Posts
    ecohen
    Dec 30, 2016

    Selecting Graded Cruises Only

    in Assisi Forum

    Rich, I am trying to run a query on cruises which have an actual quality calls on a cruise. The challenge is all stands have a grade weather we measured in field or not. How could I go about doing this only to isolate the stand which had an actual field call on logs. Let me know if you have time to discuss or respond to my email. Hope all is well. Thanks Eric

    1 comment
    0
    Rich Howard
    Dec 30, 2016

    Sounds like you are trying to find all the cruises with field called logs as opposed to cruises with only total heights called. The Logs table should have everything you need since it stores all the field called logs and grades. If there is a record in the Logs table, then there was a log called in the field. Run a query like the following: SELECT Stand FROM Logs WHERE NOT Grade IS NULL GROUP BY Stand Rich

    0
    1 comments

    © 2016 Assisi Software Corp

    • LinkedIn - Black Circle
    • YouTube - Black Circle
    Clients
    News
    Products
    Forum
    About Us
    Support