Need help on Programming?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kutest - 27 Sep 2007 20:49 GMT

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

Reply to this Message

Wolfgang Kais - 27 Sep 2007 21:36 GMT

Hello Kutest.

> 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
[quoted text clipped - 4 lines]
>
> if anyone can help that would be great!

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?

Signature

Regards,
Wolfgang

Reply to this Message

Kutest - 27 Sep 2007 22:53 GMT

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 !!

Reply to this Message

Wolfgang Kais - 28 Sep 2007 03:10 GMT

Hello Kutest.

> 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 !!

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]")

Signature

Regards,
Wolfgang

Reply to this Message

Kutest - 28 Sep 2007 17:41 GMT

Thanks man!! That worked your the best !!!

> Hello Kutest.
>
[quoted text clipped - 15 lines]
> =DSum("[Labor Total]","[Labor Totals by Workorder]") +
> DSum("[Parts Total]","[Parts Totals by Workorder]")

Reply to this Message