Adding prices

Is This that big of a problem that no one knows how to do it.

This most likely means forum is not the right place for questions like this. If you have a valid support contract contact support directly.
If you want to get help here you need to elaborate your question so it can be understood. It is not clear if you already wrote some piece of code and it didn't work or you need some general guidance or you need someone to write this code for you.
I have checked your sample page and it doesn't even have a price field so it is not clear what and how you want to add together.

The price field or prices fields are apart of the dropdown list for the dropdown and each price is showed as apart of each checkbox item.
There are 2 prices fields in it.
memberPrice and nonMemberPrice
there is no price field on the page there is only a total.
I have tried doing it is sql code only but that doesn't work.
I need to make it work on the page in javascript and have no idea how to do it.

Here is a clarification to what I am wanting to do.
As stated I need to add prices together here is how the data is now.
The page event signup has 2 lookup wizards that lookup to 2 different tables events and sub-events
This page is on the table eventsignup
The events table stores the name of the event and the price of the event as well as extra crew fee.
Field names are as follow. EventName, memberprice1, extracrewfee
The sub-events table has subevent name, memberprice1,

this is a checkbox multi-select list.
I need to add the prices together on the fly and put the total due in the total filed on event signup page.
so it would be event member price

and then each subevent memberprice added and totaled
The total is then add with the on the extra crew calculation.
Also the field number of crew is extra crew defaults at 3 but can be changed by the user the price is from the event.extracrewfee so [3 X events.extracrewfee]
SO the formula is [events.memberprice1]+[subevents.memberprice1]+[eventsignup.numberofcrew X events.extracrewfeee] = [eventsignup.totaldue]
Of course the formula may change depending on how many subevents are selected and it can be no sub events selected.

Still doesn't make any sense, at least to me.
It is not clear if you already wrote some piece of code and it didn't work or you need some general guidance or you need someone to write this code for you.
I have checked your sample page and it doesn't even have a price field so it is not clear what and how you want to add together. You cannot add something that is not on the page.

I have no code made.
I tried to do this is in SQL on a view but the sql doesn't work.
This page will not have a price field.
As I said in other reply
The prices are apart of the the tables being used in the lookup wizards.
The field name of the prices is called memberprice1.
Here is the sql that I tired first as a custom view on the view page of this page.

The non on the fly method is by using sql code to do the work.
But this sql code has to be executed before the view page is displayed.
And the IDNum is the record number of event signup I would need to get it from the record they are loading and pass it to this sql.
How do you make that work.

If you need to perform some price calculation on the page you need to have those price fields right on the page. Then you can use Javascript calculation as described in method #3 at http://xlinesoft.com/articles/how_to_use_calculated_fields.htm

Alright this is a problem that is not supported by phprunner.
Very Stupid.
Topic Closed.