I’m attempting to build a BAQ that only displays parts with multiple approved revisions. I built a basic BAQ that displays parts and revisions from the PartRev table. I’m not certain how to filter these results so it only displays parts with an approved A and B revision. I’ve attempted to do this via subqueries and subquery criteria but am unable to get the results I’m looking for. Has anyone done something similar that could point me in the right direction? select [PartRev].[PartNum] as [PartRev_PartNum], [PartRev].[RevisionNum] as [PartRev_RevisionNum], [PartRev].[Approved] as [PartRev_Approved]from Erp.PartRev as PartRevwhere (PartRev.PartNum like 'dp%') I would like the query to display only the highlighted rows.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.