var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: New to ACCESS **need help
I have Supplier names and then I also have count of parts we buy from these supplier. Which function or Criteria I should use to get Count of "Unique part numbers" from each supplier.
I am trying to use DCount
I am using Access 2010 .Query builder
Create a Total Query with the following SQL with appropriate changes:
and save the Query with the Name: QUERY1. After that you can use the following expression, as you were trying to get the required output:
SELECT [tblSpend2016].[Supplier ID], [tblSpend2016].[PART], Count([tblSpend2016].[PART]) AS PARTCNT
GROUP BY [tblSpend2016].[Supplier ID], [tblSpend2016].[PART];
Insert the correct supplier ID in place of XYZ123. Insert the correct Supplier information in place of [Supplier ID] in the SQL and in the =DSUM() function as well.
Last edited by apr pillai; 09-19-16 at 14:14.
Reason: correction of text
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007