Search results

Apologies, I had the SQL wrong, it should be; TRANSFORM Count(tblReportData.ID) AS CountOfID SELECT tblReportData.Agent, Count(tblReportData.ID) AS [Total Of ID] FROM tblReportData GROUP BY tblReportData.Agent PIVOT tblReportData.County; And the error in the compiler is; Server Error in...

Got that, thanks. But the compiler doesn't like it. The SQL query is; TRANSFORM Count(tblReportData.[Number of Properties]) AS [CountOfNumber of Properties] SELECT tblReportData.Agent, Count(tblReportData.[Number of Properties]) AS [Total Of Number of Properties] FROM tblReportData GROUP BY...

I clicked the wrong field value. When i went back and selected sum it worked fine! I need to import this data into a .Net Web Service, could anyone tell me if there is a way to write my query to a table or if I can get the query in an SQL statement I can use in the Web Service?

Thanks for the input JohnLee. I've given that a go and its close to what i want but I'm not sure how to get total? I'll explain my problem a bit more: I have a table with a list of Properties. Each property has an ID, Property Agent, Price, Location etc. All I want is the Property Agent...

Hi, I'm very new to access and only have the basics of SQL. I have a table of Names and the county they are connected to. These names appear multiple times in a county. I'm looking for a way to count the number of times each name appears and show it beside each name and county in a display...