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
To see this working, head to your live site.
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