Calculating by record and by group

[Mitchy]

I am currently tracking machine production daily and comparing that to a fixed goal as a percentage of completion. Since I have four different machines, I stored each of the goals in a table which ties a machine to its particular goal. For each date, I have a report that will show the daily percentage of the target goal. This is working fine. I want to add a feature that will group a set of dates together, by some set time period, and will then total the production. When I try and use the fixed goal to measure the performance of the totals, I get an error message. Is there a way I can get this figure to work in this application?

 

[PHV]

I get an error message
Any chance you could post the whole error message and the code you tried ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Mitchy]

Thanks for your response PH. It turns out that I was just not using the square bracket vs parenthisis SP wrong. Once I straightened this out, it worked fine.

Thanks again,

Mitchy