Syntax Error (missing Operator) in query expression

Hello everyone.

This problem (or error) involves some minor SQL programming. However the coding is done in and Excel '97 enviroment and involves an Excel userform.

So, I have a syntax error that is occuring after I attempted to insert two new string items into a string variable called strVol.The two additional items are SubPort and PartialMargin.

Let me first walk you through the userform:

1. The user is requested to Add Volume -

Please Login or Register  to view this content.

A frame that was hidden on the userform then appears and the user populate the various fields namely: Port, SubPort, Product, Volume and then Margin. The user than "Saves The Volume"

Please Login or Register  to view this content.

Now According to the immediate window:

Please Login or Register  to view this content.

which is correct, here CARRIBEAN is an example of a Port and AGUSTA a subport and so fourth. I suspect the double and single qoutes around PartialVolume and PartialMargin are incorrect.

You have mismatched single quotes. There should be one after 'CARIBBEAN and I suspect there should not be one before the 1000 as the second last value.

This bit:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

Well, then you need to put it back since it was there before!