Isolating stands that have actual field grade calls on logs
- This topic has 1 reply, 2 voices, and was last updated 9 years, 7 months ago by
.
-
Posts
-
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
EricSounds 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
- You must be logged in to reply to this topic.