Hello, I am receiving the error from my Query below: "Wrong number of arguments used with function in query expression 'Sum(Round([BFPercent]*[Weight]),2) AS BFPounds'. If I remove the ,2 from it the query executes just fine.
I thought the ROUND function allows for that additional parameter to define where the rounding shall occur?
INSERT INTO CheckStubInfo ( Grade, PatronNo, [BF%], [Protein%], [OS%], Bacteria, SCC, [Milk Lbs], [date], [BF Lbs], [Protein Lbs], [OS Lbs] )
SELECT Patron.PatronGrade, Patron.PatronNumber AS Main, [Premium Info].BFPercent, [Premium Info].ProteinPercent, [Premium Info].OSSPercent, [Premium Info].Bacteria, [Premium Info].SCC, Sum(PatronWeights.Weight) AS SumOfWeight, [Premium Info].Date, Sum(Round([BFPercent]*[Weight]),2) AS BFPounds, Sum(Round([ProteinPercent]*[Weight]),2) AS ProteinPounds, Sum(Round([OSSPercent]*[Weight]),2) AS OSPounds
FROM [Premium Info] RIGHT JOIN (PatronWeights LEFT JOIN Patron ON PatronWeights.PatronNo = Patron.PatronNumber) ON [Premium Info].PatronNo = PatronWeights.PatronNo
WHERE (((PatronWeights.PickUpDate) Between [Please enter a beginning pickup date:] And [Please enter an ending pickup date:]) AND (([Premium Info].Date)=[Please enter an ending pickup date:]))
GROUP BY Patron.PatronGrade, Patron.PatronNumber, [Premium Info].BFPercent, [Premium Info].ProteinPercent, [Premium Info].OSSPercent, [Premium Info].Bacteria, [Premium Info].SCC, [Premium Info].Date, Patron.SplitPatron1, Patron.SplitPatron2, Patron.SplitPatron3
HAVING (((Patron.PatronNumber) Is Not Null) AND ((Patron.SplitPatron1) Is Null) AND ((Patron.SplitPatron2) Is Null) AND ((Patron.SplitPatron3) Is Null) AND (([Premium Info].date)=[Please enter an ending pickup date:]));
I thought the ROUND function allows for that additional parameter to define where the rounding shall occur?
INSERT INTO CheckStubInfo ( Grade, PatronNo, [BF%], [Protein%], [OS%], Bacteria, SCC, [Milk Lbs], [date], [BF Lbs], [Protein Lbs], [OS Lbs] )
SELECT Patron.PatronGrade, Patron.PatronNumber AS Main, [Premium Info].BFPercent, [Premium Info].ProteinPercent, [Premium Info].OSSPercent, [Premium Info].Bacteria, [Premium Info].SCC, Sum(PatronWeights.Weight) AS SumOfWeight, [Premium Info].Date, Sum(Round([BFPercent]*[Weight]),2) AS BFPounds, Sum(Round([ProteinPercent]*[Weight]),2) AS ProteinPounds, Sum(Round([OSSPercent]*[Weight]),2) AS OSPounds
FROM [Premium Info] RIGHT JOIN (PatronWeights LEFT JOIN Patron ON PatronWeights.PatronNo = Patron.PatronNumber) ON [Premium Info].PatronNo = PatronWeights.PatronNo
WHERE (((PatronWeights.PickUpDate) Between [Please enter a beginning pickup date:] And [Please enter an ending pickup date:]) AND (([Premium Info].Date)=[Please enter an ending pickup date:]))
GROUP BY Patron.PatronGrade, Patron.PatronNumber, [Premium Info].BFPercent, [Premium Info].ProteinPercent, [Premium Info].OSSPercent, [Premium Info].Bacteria, [Premium Info].SCC, [Premium Info].Date, Patron.SplitPatron1, Patron.SplitPatron2, Patron.SplitPatron3
HAVING (((Patron.PatronNumber) Is Not Null) AND ((Patron.SplitPatron1) Is Null) AND ((Patron.SplitPatron2) Is Null) AND ((Patron.SplitPatron3) Is Null) AND (([Premium Info].date)=[Please enter an ending pickup date:]));