Need help on Programming?

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

Guest

I have a problem with my form...I'm trying to make a subtotal field on a
form, that would subtotal 2 queries. ie, total part and total labor...
but it keeps saying # ERROR what does that mean???
I just need some help to get this thing fixed for work... i've gone through
other errors but this is like one of the last problems that i have and it
sucks!!!

if anyone can help that would be great!1
 
Hello Kutest.

Kutest said:
I have a problem with my form...I'm trying to make a subtotal field
on a form, that would subtotal 2 queries. ie, total part and total
labor... but it keeps saying # ERROR what does that mean???
I just need some help to get this thing fixed for work... i've gone
through other errors but this is like one of the last problems that
i have and it sucks!!!

if anyone can help that would be great!
Click to expand...

What do you mean when saying subtotal? A total? If so and if a field
in the recordsource was named qty, you could add a textbox to the
form footer and calculate a total using "=Sum([qty])" without quotes.
If this is not working, what is your formula?
 
My formula is =Sum([Labor Totals by Workorder]![Labor Total]+[Parts Totals by
Workorder]![Parts Total])

I had a different formula but that one gave me the same '#ERROR' error
message so i tried this one but it doesnt work either... if you can give me
some pointers that would be great !!
 
Hello Kutest.

Kutest said:
My formula is =Sum([Labor Totals by Workorder]![Labor Total]+
[Parts Totals by Workorder]![Parts Total])

I had a different formula but that one gave me the same '#ERROR'
error message so i tried this one but it doesnt work either... if
you can give me some pointers that would be great !!
Click to expand...

What are [Labor Totals by Workorder] and [Parts Totals by Workorder]?
When using your sum formula in the footer of the form, the fomula
inside the brackets must not contain controls with calculated
expressions but must consist of fields of the query the form is based
on.
It seems to me that [Parts Totals by Workorder] and the other one are
queries in your database that you try to access this way, which is not
allowed. Maybe your formula should be written this way:
=DSum("[Labor Total]","[Labor Totals by Workorder]") +
DSum("[Parts Total]","[Parts Totals by Workorder]")
 
Thanks man!! That worked your the best !!!
:

Hello Kutest.

Kutest said:
My formula is =Sum([Labor Totals by Workorder]![Labor Total]+
[Parts Totals by Workorder]![Parts Total])

I had a different formula but that one gave me the same '#ERROR'
error message so i tried this one but it doesnt work either... if
you can give me some pointers that would be great !!
Click to expand...

What are [Labor Totals by Workorder] and [Parts Totals by Workorder]?
When using your sum formula in the footer of the form, the fomula
inside the brackets must not contain controls with calculated
expressions but must consist of fields of the query the form is based
on.
It seems to me that [Parts Totals by Workorder] and the other one are
queries in your database that you try to access this way, which is not
allowed. Maybe your formula should be written this way:
=DSum("[Labor Total]","[Labor Totals by Workorder]") +
DSum("[Parts Total]","[Parts Totals by Workorder]")
Click to expand...
 
Back
Top