Duplicate records/numbers/values

  • Thread starter Thread starter Evelyn Williams
  • Start date Start date
E

Evelyn Williams

Please help me....please remember...I'm very very very new to Access.
I have tried to hide duplicates, =Abs(Sum([Req #])), DCount, two queries and
other group suggestions and the total count for the column still is not
right. Can someone please tell me what I'm doing wrong. The report is due
tomorrow!!!!!

This is a partial portion of what the report resembles:

Vendor: Kelly Girls # Candidates Submitted 6 # Req 6 (Count
s/be 1)

Date Candidate Name Req #
1/23/09 Susan Smith 00-099
5/16/09 Thom Green 00-099
10/6/09 Mike Jones 00-099
10/19/09 Sally Williams 00-099
10/22/09 Martin Brown 00-099
10/22/09 John Henry 00-099
(Only one req # for all 6 candidates was really used)

Acct Temps # Candidates Submitted 3 # Req 3 (Count s/be 2)

Date Candidate Name Req #
2/15/09 Tom Smith 00-023
5/16/09 Susan Green 00-023
10/6/09 Kathy Jones 00-021
(Two req numbers were used 00-023 and 00-021, not three)

I need the report to count the req number, as one and skip the other req #
that are the same and not sum all req numbers for that vendor. Most of the
variations have given me an error or removed the # Req caption completely.
PLEASE HELP, ME!!!!
 
UNTESTED UNTESTED ---
SELECT [YourTable].[Date], [YourTable].[Candidate Name], (SELECT
Count(SELECT [Req #] FROM [YourTable] AS [XX] GROUP BY [XX],[Reg #]))) AS
Reg_Qty
FROM [YourTable];
 
Back
Top