R
Repent
John;
now that I have that working....
I want to find the waste% using the sums available. For example, I
have summed up colums for LF Run, LF Produced, and waste.
I want the waste% based on dividing the summed totals of waste by the
summed totals of LF Run.
I tried the code of =Sum([waste])/Sum([LFrun]) but when i run that it
asks for a value, like a query parameter. I just want it to take the
summed value for waste and divide it by the summed value for LFrun.
I thought the code i show above would do that. What do I have wrong?
chris
John;
thanks for the info and the leads! I changed the type to "numbers"
instead of "text" in the field type in the table (as I am pulling the
data from a table field). That did the trick.
I could then see that "sum" was unghosted and available to me.
I could then also create groups using the group & sort wizards and get
the totals I am looking for.
Once again, thanks for the info. I wracked my brain way too long
yesterday on this.
chris
now that I have that working....
I want to find the waste% using the sums available. For example, I
have summed up colums for LF Run, LF Produced, and waste.
I want the waste% based on dividing the summed totals of waste by the
summed totals of LF Run.
I tried the code of =Sum([waste])/Sum([LFrun]) but when i run that it
asks for a value, like a query parameter. I just want it to take the
summed value for waste and divide it by the summed value for LFrun.
I thought the code i show above would do that. What do I have wrong?
chris
John;
thanks for the info and the leads! I changed the type to "numbers"
instead of "text" in the field type in the table (as I am pulling the
data from a table field). That did the trick.
I could then see that "sum" was unghosted and available to me.
I could then also create groups using the group & sort wizards and get
the totals I am looking for.
Once again, thanks for the info. I wracked my brain way too long
yesterday on this.
chris
The control is a text box. The control has a control source and usually that
is a FIELD in a TABLE or QUERY.
What is the field type in the table? If it is text then you cannot sum it.
If it is a number then you should be able to sum it.
If you are using the table directly, you have to change the field type. If
you are using a query as the source you can use VAL function to change the
text to a number type. You would need a calculated column to do this. OR
open the report in design view, change the control name to txtLFRun and then
change its source to
=Val([Lf Run] & "")
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
The property sheet for "LF Run" shows that it is a text box. it
contains numbers. Is this t he problem? How can I fix that?