Filter records be initial appointment type but then include all subsequent entries (1 Viewer)

[gojets1721]

Apologies for the likely confusing title. I've included an example database.

Essentially, I'm looking to create a query that filters down to all 'inspection' appointment types, but also includes any subsequent appointments regardless of type. So if the customer had a different appointment type after the inspection, those would be included in the query too.

Please let me know if I didn't explain it well enough. I'm basically trying to query down to additional appts that could have been triggered from an inspection (in my actual database)

Thanks

 

[arnelgp]

Union Query?

 

[plog]

Build a query to find the first Inspection date for each CustomerID. Then build another query using that query and your table to pull all the records of those customers that occured after their first inspection date.

 

[gojets1721]

So I created a query to find the first inspection date. I'm not sure how to do the second part too in regard to using that query with the original table to find the other appts tho

 

[arnelgp]

see Query1.

 

[plog]

What does your first query look like? Post the SQL or another database.

 

[arnelgp]

See also Query2.