Good Day Experts!
Can you help with a query design?
I have multiple lines of records in a table that make up a Batch of data...lets call it Batch 1234 and give it 5 records. On each record is a field called Shipped. It is either a 1 or a 0 value.
I need a query that 1) Tells me if Batch 1234 is present in the table and 2) if any of the records in the batch have Shipped set to 1
Is this possible in one query without too much trouble?