Thanks good people for your prompt responses.

Ok, let me see what additional information I can provide.

The form is divided into 4 sections.

The first section collects Requestor (the employee making a...

Thanks for all your help - much appreciated.

Thank you very much Sean for the prompt response.

First, I had done it the way you just did it but my boss raised the same concurrency issue that you just...

Thanks Sean and Eric.

I actually, Sean, I had not sean Eric's response till now.

The SurveyMonkey link is written in php and I don't know php.

I did, however, download a copy...

J, thanks for your prompt response.

Each question will have a question Type. Is it radio button, checkbox, comment box?

I am not really sure if this is relevant but that's what...

I figured it out. thanks

First, I am no longer using the sample you just posted.

I am using the msdb.send_dbMail component.

This now works perfectly on my test server which runs on Windows Server 2003 and...

Hi Jeff,

I read any articel written by you.

They are enriching and helpful.

About my issue, I have resolved it.

I am now using send_dbMail. As it turns out, I was not using...

That's exactly what I had to do - use UNION.

The first select statement selected the fieldnames - agencyName, check, Cash

The second select after UNION selected the 'Total' as first column,...

Actually, John, it isn't a duplicate.

You did such a fantastic job. It is the Rollup that adds the extra null as it "rolls" up the totals.

It would have been great...

John, thank you very very much for taking the time to put this elaborate explanations plus the code.

It is much appreciated.

Only problem I have so far is that if I...

Hi Ronald,

I agree with only your fourth argument.

Thanks a lot for taking the time to give your feedback.

Much appreciated.

Thank you Palash; you are great.

I think I figured out the problem.

THis is sample data for check:

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

0.0000

20.0000

Cash has similar values.

Notice the extra 00s. I guess I will have to divide...

have 2 columns check and cash, laid out like this:

Check Cash

129.00 00

10.00...

Hi J,

Do you still what you asked for?

Thanks for your response.