Sam Summers
Registered User.
- Local time
- Today, 12:57
- Joined
- Sep 17, 2001
- Messages
- 939
Hi there,
I have created a crosstab query and corresponding subreport. Now crosstab queries are new to me.
I need to only display the records pertaining to the associated JobNo or LocationID on the main report but whatever I try, when I come to link the reports, the above fields are not visible so I am doing something wrong?
The SQL for the query is:
TRANSFORM Count(ItemsInKits.EquipmentID) AS CountOfEquipmentID
SELECT ItemsInKits.EquipDescription
FROM (ItemsInKits
INNER JOIN Location ON ItemsInKits.LocationID = Location.LocationID)
INNER JOIN Equipment ON (Location.LocationID = Equipment.LocationID)
AND (ItemsInKits.EquipmentID = Equipment.EquipmentID)
GROUP BY ItemsInKits.EquipDescription, Equipment.LocationID, Location.JobNo
PIVOT ItemsInKits.KitNumber;
Many thanks in advance
I have created a crosstab query and corresponding subreport. Now crosstab queries are new to me.
I need to only display the records pertaining to the associated JobNo or LocationID on the main report but whatever I try, when I come to link the reports, the above fields are not visible so I am doing something wrong?
The SQL for the query is:
TRANSFORM Count(ItemsInKits.EquipmentID) AS CountOfEquipmentID
SELECT ItemsInKits.EquipDescription
FROM (ItemsInKits
INNER JOIN Location ON ItemsInKits.LocationID = Location.LocationID)
INNER JOIN Equipment ON (Location.LocationID = Equipment.LocationID)
AND (ItemsInKits.EquipmentID = Equipment.EquipmentID)
GROUP BY ItemsInKits.EquipDescription, Equipment.LocationID, Location.JobNo
PIVOT ItemsInKits.KitNumber;
Many thanks in advance