SELECT PERMINFO.[Permit Number] AS Expr1, Admin2.[Application Filing] AS Expr2, Admin2.[Application Decision] AS Expr3, Admin2.Status AS Expr4, PERMINFO.[Alpha 1] AS Expr5, PERMINFO.[Alpha 2] AS Expr6, PERMINFO.[Alpha 4] AS Expr7, PERMINFO.[Alpha 5] AS Expr8, PERMINFO.[Alpha 6] AS Expr9, PERMINFO.[Alpha 10] AS Expr10, Parcel.*
FROM Admin2, PERMINFO, Parcel
WHERE ((([PERMINFO].[Permit Number]) Like ("BP*")) AND (([Admin2].[Application Decision]) Between [Forms]![ARC Report]![Start Date] And [Forms]![ARC Report]![Ending Date]) AND (([PERMINFO].[Alpha 5])="Residential" Or ([PERMINFO].[Alpha 5]) Is Null));