Adirudik thank you for your answer. I don't know if this is the right solution because inserting images through MS Access can give all sorts of problems (an OLE-object in...

You were right: express edition. The articles are looking promising.

Thanks for your help.

Robert

Thanks Craig for your answer. I have a front-end Access-2007 and I know what the report possibilities are. I was just wondering if things could be done in sql server....

I'm using a T-SQL query. I'm not familiar with SSRS. Can you explain that a bit further?

Thanks Lynn, no problems anymore with the temp table

Good question: it is a hobby resulting in a website. This website is based on a sql server database. I'll let you know when the site is up and running....

Guys,

I did the following and it worked!!! You did a great job learning me this, thanks a lot to the joined forces LutzM and FlatDixie:

...

Guys,

I did the following and it worked!!! You did a great job learning me this, thanks a lot to the joined forces LutzM and FlatDixie:

...

Looks good, but remember I am a newbie. So things are going to fast for me. First the beginning: ; with cte as - what is the meaning of this?...

I encounter two problems with the temp solution: union demands the same number of columns and score is an nvarchar, so the isnull gives an error (it evaluates as an...

This is the raw material before the cross tab query. I don't know how to bring it any further like the etiquette (text mode? query analyzer?). perhaps you can past...

I am not sure I get the grips. To clear things up I give you the following code:

SELECT TOP (100) PERCENT Koersnaam, COUNT(Koersid) AS Totaal, MAX(CASE...

Hello Mark,

You have earned your points: MAX did the trick! I tried SUM, COUNT, Etc but not MAX. Thanks for your answer.

Greetings,

Robert