Author: Dale Fye Date: Sep 4, 2008 17:03
From the looks of your query, and your comment that the query would only
return two columns, I can only assume that your tblControlFile table contains
only a single record. Is that Accurate?
In this case, I don't think you need a Crosstab Query. Why not just do an
aggregate query. Something like:
SELECT lessee.lessee, Sum(tblSales.amount) AS Amount
FROM (lessee INNER JOIN (gamemaster INNER JOIN tblSales ON (gamemaster.game
= tblSales.game) AND (gamemaster.game = tblSales.game)) ON lessee.lessee =
gamemaster.lessee) INNER JOIN tblControlFile ON tblSales.fairdate =
GROUP BY lessee.lessee
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only.