Re: mimic a pivot table query

Of course, of course... always the simplest way you never see. Thanks again, superb. cheers Martin >Hello Martin, > >>select >> user_name, > >>, > >There is - move the user_name column to the end of the select list - >that way you always include a "," character...

RE: mimic a pivot table query

Hello Martin, >select > user_name, >, There is - move the user_name column to the end of the select list - that way you always include a "," character... Happy to help, /t ~| Introducing the Fusi

Re: mimic a pivot table query

Hello Tanguy. Thanks for the response. Yeah I found a similar example on the web. Yeah it is a bummer that you need to know the field names but I have done a fudge by running a query to get all field names and then using this to build the query dynamically. Thanks for the query that is exact

Re: mimic a pivot table query

Hello Martin, Assuming (yes, i know) that you know all the possible values of the 'APP' column, you could acheive this with correlated subqueries: SELECT DISTINCT username, (SELECT SUM (appcount) FROM myTable indata WHERE indata.username = myTable.username AND indata.app

mimic a pivot table query

Hello all. I have been given an access database and am converting in into a CF web app. There are some queries that I need to mimic which use pivot tables and I am having trouble figuring out the best way to get the results that are required. Here is the scenario: One view with the follow