SQL Error...

[Stephanie53]

I am getting this error.

I have [QTY] in another area for ExtPrice but also need it for TotWght too for the same item.

How can I get passed this and have it give me the total weight of the product too..this is detrimental for shipping purpose and getting the cost of it on the Quote

TIA!!



Stephanie :-)

[June7]

Why is there more than one field in the query with the same name?

Show the complete SQL statement for analysis.

[Stephanie53]

ok i misquoted...here is what i am doing:

I finally got it to caculate yesterday as you well know on the Hoses (PrimaryID)

Now I am creating the SubpartsID for the attachments for this said hose (there is about 10 different things that have to be done to this hose for the oil industry...

the idea that I am trying to do here is this...

When they select a hose then have it automatically go to the next section to order the fittings and the end caps...

its the same format as the Hose Form..but now this one is called Swage Form (type of fitting)..it has Qty, UnitCost, NetWght and TotWght

I pretty much have to do the same with the caculations on Qty & UnitCost AND Qty & NetWght

But give me a second..I just got back to this form..and I think i may have solved this problem...I will let you know if i did and what i did to solve it...

[Stephanie53]

ok its working now...not sure what i did differently then before but its working now...ughhh

As I said by the time i am done with this darn thing i am going to be a PRO!! LOL

I know I am going to asking for help again here soon...so keep on the look out..lol

Thanks!!