gojets1721
Registered User.
- Local time
- Today, 16:37
- Joined
- Jun 11, 2019
- Messages
- 429
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
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