Deriving a total from a continuous form?

[StupidStudent]

Hi people just wandering if i can get a bit of help please??

I have a "suppOrder" form and within it there is a "suppOrderLn" form and suppOrderLn is the continuous form. However within suppOrderLn there is a line total. Within suppOrder there is an Order Total.

Is there any way that i can get Order Total to find the sum of all line totals??

Any help would be awsome??!?

thanks

 

[boblarson]

In the subform footer, place a text box and then set it's controlsource to be

=Sum(PutTheCalculationHere)

 

[StupidStudent]

Thanks for the super quick reply!!!!

However after trying this solution i just keep getting an #error message

This is what I have =Sum([Supplier Order Line.SuppLineTota])

sorry about this but i am new to access and have been trying to find this outfor a while

thanks again

 

[boblarson]

Sorry, you need to put the actual calculation within the ().

 

[StupidStudent]

Hi again

I know this is crazy and yes i am slow.....

But how would I calculate something where i dont know how many things need to be calculated??

Sorry hence the id!!

 

[boblarson]

=Sum([Supplier Order Line].[SuppLineTota])

I think you were missing two brackets.

 

[StupidStudent]

Thanks again for quick reply.....

unfortunatly still getting error messages??
would this be better on the after update method on the line total??

you people rock!!

 

[boblarson]

Make sure that your text box that displays SuppLineTotal is not named the same (should be txtSuppLineTotal) as Access is likely getting confused with which to use, the form or the field, and you need to use the field.

 

[StupidStudent]

Thanks

Still getting error lol i guess back to the drawing board!!

thanks again

 

[boblarson]

If you can compact (Tools > Database Tools > Compact and Repair) and then zip your database up and post it here, I could take a look.

 

[StupidStudent]

Thank you so much

u are a god!!

 

[StupidStudent]

unfortunatly i can only get it down to 513 which is to big to post

 

[boblarson]

I'll PM you with my email address so you can email it.

 

[boblarson]

Okay, it was like I thought. You had to add a text box to your SUBFORM footer and then reference it in your main form. See the database for how I did it. You can download it here:
http://downloads.btlarson.com/AWF/samples/oliveAndgingertrial_rev03-19-2007.zip

 

[Wiz47]

Okay, it was like I thought. You had to add a text box to your SUBFORM footer and then reference it in your main form. See the database for how I did it. You can download it here:
http://downloads.btlarson.com/AWF/samples/oliveAndgingertrial_rev03-19-2007.zip

Bob, maybe you could include a small sample db in the Examples db section. I answered a similar question just a few days ago. It seems like this is a common problem when trying to sum numbers in a main form from a subform.

 

[boblarson]

It seems like this is a common problem when trying to sum numbers in a main form from a subform.

Subforms are a common problem, period. They aren't all that easy to learn at first and they have so many strange quirks that it can drive you batty. I think there are already some samples in the samples forum, but I can try to look and see.

 

[StupidStudent]

Thanks again u know your stuff!!!!!

ur a light saber!!