how to associate the request with an existing form? Please see attached file.

[vugar]

but there not show records

[vugar]

When I link master and child field there was eror that shown in photo.

[June7]

The image I posted was design view of form.

I did not try to set Master/Child links so that is new info for me to work with. Now I get the same error. I've never really needed CROSSTAB queries so am learning new stuff.

This brings us back to the recommendation to use the method described in Allen Browne article. Revise the CROSSTAB query:

TRANSFORM Sum(AssetSum.TotalDue) AS SumOfTotalDue
SELECT [Item List].ECID, [Equipment Categories].Main, [Equipment Categories].[Sub-Category], AssetSum.ItemID, [Item List].Equipment, [Item List].Details, [Item List].SerialNumber, [Item List].Size
FROM [Equipment Categories] RIGHT JOIN ((AssetSum LEFT JOIN [Project List] ON AssetSum.CostCenterID = [Project List].CostCenterID) LEFT JOIN [Item List] ON AssetSum.ItemID = [Item List].ItemID) ON [Equipment Categories].ECID = [Item List].ECID
GROUP BY [Item List].ECID, [Equipment Categories].Main, [Equipment Categories].[Sub-Category], AssetSum.ItemID, [Item List].Equipment, [Item List].Details, [Item List].SerialNumber, [Item List].Size
PIVOT [Project List].CostCenter In ("HQ","Lab","Mini-Office","New Office","New Yard","Yard");

[vugar]

Sorry. Where I can paste it?

[June7]

Just modify your existing query with the additional text in red.

Can copy/paste in the query SQL view.

[vugar]

Thank you very very much. ;-)
And when I want add new project I must to add to into this list?

[June7]

Yes. And modify form or report for another textbox.

[vugar]

Thank you very very much.