Access to SQL conversion

[StateSQLboy]

I have an Access crosstab query that I need to make into a stored proc in SQL. My query looks like this:
TRANSFORM Count(Programs.Unit_No) AS [The Value]
SELECT Programs.LicNo, Count(Programs.Unit_No) AS [Total Of Unit_No]
FROM Programs
GROUP BY Programs.LicNo
PIVOT Programs.Program_No;

SQL will not accept Transform, or Pivot.... How do I correct this to work with SQL?

 

[Patrick2002]

Do you have the database in SQL Server, or did you create a linked server to the Access DB ? Why don't you just explain what you want to do with which fields, that 'll be easier. This is, after all, no Access forum