For summing if name is in one of 3 fields with a date time frame

[brow1726]

So I have been at this for a few days and I am stumped. I am trying to pull names from one table and if there name is in either position A, B, or C it will take that number and sum it with the rest that match within the given dates through textboxes. I am not sure if maybe I am using the criteria or wrong or what but I cant get it to correctly fire. When I do get it to pull the right data it pulls everythin from the Data Table and not just for the requested dates. Anyone have any ideas?



Thanks in advance,

Matt

[June7]

What is position A, B, or C - are these fields? If so, sounds like non-normalized data structure. Need something to analyse. Provide the sql of attempted query or follow instructions at bottom of my post to provide db.

[brow1726]

Yes they are fields. I am entering production data for 3 person work stations. But the people in the cell change week to week. So what I want to do with the query is say for the month of august I want to see the number totals for all the people broken down by processor.

Here is the SQL:

SELECT Processor.Processor, Sum(TrackingTable.ActualProduction) AS SumOfActualProduction, Sum(TrackingTable.Goal) AS SumOfGoal, Avg(TrackingTable.Percentage) AS AvgOfPercentage
FROM Processor, TrackingTable
WHERE (((TrackingTable.Scan)=[Processor]![Processor]) AND ((TrackingTable.EntryDate) Between [Forms]![Queries]![StartDate].[Value] And [Forms]![Queries]![EndDate].[Value])) OR (((TrackingTable.Validation)=[Processor]![Processor])) OR (((TrackingTable.Verification)=[Processor]![Processor]))
GROUP BY Processor.Processor, TrackingTable.Training
HAVING (((TrackingTable.Training) Not In ("Yes")));
Thanks for any help!!

[June7]

You want the total per person per processor? I don't see anything in that query and looks like position fields. Use a UNION query to normalize the data.

SELECT "A" As Position, PositionA AS StaffName, {other fields as desired} FROM tablename
UNION SELECT "B", PositionB, {other fields as desired} FROM tablename
UNION SELECT "C", PositionC, {other fields as desired} FROM tablename;

Now use that query in other queries to summarize, filter, sort, calculate data.