Code:
SELECT [Phone Common Things].[Phone ID], [Phone Common Things].[Phone Name]
FROM ([Phone Types - 64GB] INNER JOIN ([Phone Types - 32GB] INNER JOIN (Companys INNER JOIN [Phone Common Things] ON Companys.[Company ID] = [Phone Common Things].[Company ID]) ON [Phone Types - 32GB].[Phone ID 32GB] = [Phone Common Things].[Phone ID]) ON [Phone Types - 64GB].[Phone ID 64GB] = [Phone Common Things].[Phone ID]) INNER JOIN (Customers INNER JOIN Sales ON Customers.[Customer ID] = Sales.[Customer ID]) ON [Phone Common Things].[Phone ID] = Sales.[Phone ID]
GROUP BY [Phone Common Things].[Phone ID], [Phone Common Things].[Phone Name]
HAVING ((([Phone Common Things].[Phone ID])=[Forms]![A_Main]![Stats_Input]))
SELECT PhoneID, Sum(IIf([PhoneType]="32GB",1,Null)) AS Count32, Sum(IIf([PhoneType]="64GB",1,Null)) AS Count64 FROM Sales GROUP BY PhoneID;
im getting error from this, did i past it correctly?