views:

39

answers:

0

Hi, I am attempting to convert an access cross tab query to SQL, and am hoping someone here can help me in the process.

The access query is:

TRANSFORM First(tbl_Proj_Budget.BUGDET_LINE_BURDENED_COST) AS FirstOfBUGDET_LINE_BURDENED_COST
SELECT tbl_Proj_Budget.PROJ_ID, First(tbl_Proj_Budget.BUSDET_LINE_BURDENED_COST) AS [Total Of BUGDET_LINE_BURDENED_COST]
FROM tbl_Proj_Budget
GROUP BY tbl_Proj_Budget.PROJ_ID
PIVOT tbl_Proj_Budget.RESOURCE_LIST_ALIAS;

Can someone explain the first line of the query (and how would I proceed )
TRANSFORM First(tbl_Proj_Budget.BUGDET_LINE_BURDENED_COST) AS FirstOfBUSDET_LINE_BURDENED_COST

Thanks