I have a table 'LeadHistory' which has among others, the following
fields.
Salesman(Text)
SalesmanAssmntDate(Date/Time)
Disposition(Text)
I also have a table 'LookUpSalesman' which has among others, these
following fields.
Salesman(Text)
NumSits(Number)
NumSales(Number)
I'm trying to make a query or queries which would count the records in
[LeadHistory].[Disposition] = "Sit Assigned" for each Salesman, and
then update the [LookupSalesman] table with these counts accordingly.
Now I'm stumped. I attempted to design the query to update the
'LookUpSalesman' table.
UPDATE LookUpSalesman SET LookUpSalesman.NumSits = DCount("
[LeadHistory]![Disposition]","LeadHistory","[LeadHistory]![Disposition]
= ""Sit Assigned waiting Disposition"" ");
It updates every salesman's 'NumSits' field with the total count of
"Sit Assigned" occurrences in the 'LeadHistory', regardless of who the
salesman was.
What I need is to update each salesman's 'NumSits' field with "Sit
Assigned" occurrence count for only those records that match his name.
I'm not a programmer and don't know how to do this, though I've tried
for 2 days now. Could someone help? Please?