parameter query with calculated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run parameter (user entry) to limit records shown on a totals
field in a query. I need the totals field to act as a running total but then
limit it to the input of number the user enters in the parameter. The Totals
field does not run a total in sum it only brings up the total for each entry.
This never matches the number entered. ie the user will put ex 40 into the
parameter "EnterPension Hours Reported" in the criteria of the Pen Total Hrs
Field in query set for Sum(Iff([Pen Reconciled]="No",[Pen Total Hrs],"0")).
Help I am new to Access and I am not familar at all with SQL or VB.
 
Don

Please post the SQL statement of your query. We aren't there, so we can't
see how you've tried to build it?
 
I hope this helps, Thank you Jeff :
SELECT Time.[Time Table Index], Time.EntryDate, Time.[Pay Period Ending
Date], Time.[Pen Total Hrs], Time.[Pen Reconciled], Time.[Pen Reporting
Date], Sum(IIf([Pen Reconciled]<>Yes,[Pen Total Hrs],0)) AS [Cumulative Hrs]
FROM [Time]
GROUP BY Time.[Time Table Index], Time.EntryDate, Time.[Pay Period Ending
Date], Time.[Pen Total Hrs], Time.[Pen Reconciled], Time.[Pen Reporting Date]
HAVING (((Sum(IIf([Pen Reconciled]<>Yes,[Pen Total Hrs],0)))=[Enter Pension
Hours Reported]))
ORDER BY Time.[Time Table Index];


Jeff Boyce said:
Don

Please post the SQL statement of your query. We aren't there, so we can't
see how you've tried to build it?

--
More info, please ...

Jeff Boyce
<Access MVP>

Don Bryant said:
I am trying to run parameter (user entry) to limit records shown on a totals
field in a query. I need the totals field to act as a running total but then
limit it to the input of number the user enters in the parameter. The Totals
field does not run a total in sum it only brings up the total for each entry.
This never matches the number entered. ie the user will put ex 40 into the
parameter "EnterPension Hours Reported" in the criteria of the Pen Total Hrs
Field in query set for Sum(Iff([Pen Reconciled]="No",[Pen Total Hrs],"0")).
Help I am new to Access and I am not familar at all with SQL or VB.
Click to expand...
Click to expand...
 
Back
Top