Sure, I would love to share what I tried and what worked.

What would I need to do?

Arun Samuel

Don't know if you are still looking.

One of the better sites to start with: www. asp.net

Need to learn to design a page with graphics, layout controls for the content etc....

Yes, I hould have posted to an asp forum.

But, thanks for the tip, it's certainly in the right direction.

Thanks,

Arun

More info on this error.

Type mismatch: 'FormatNumber'

Thanks,

Arun

Chris,

I added the tblSessions to take care of an error in the ASP report, a little while ago.

Here is the snippet of the filter that is sent in:

one of the...

Great. It works! 🙂

Thanks a bunch.

Arun

I will try your suggestions.

Thanks,

Arun

I misspelt it while posting.

The error does say TblSessions.SessionLocName.

I'll try that.

Thanks for the suggestions.

Modify this:

SELECT batchid, description, merchantno, settlementdate, amount

INTO #batch_detail

SELECT DISTINCT batchid, description, merchantno, settlementdate, amount INTO #batch_detail

HTH,

Arun

There was a typo in the S.SessionsLocName, it should read S.SessionLocName

Thanks,

Arun

Continuing with the above query, trying to do the following, but gives an error saying multi-part identifier S.SessionsLocName could not be bound

SELECT COUNT(C.CaseID) AS CaseCount

FROM tblCaseInfo C

JOIN tblSessions S...

That did it.

You made it look so easy.

Thanks,

Arun

Thanks for the suggestions.

I will try them out.

Arun