I have a report that uses a cross tab qry as its basis.
My crosstab qry returns no records, (it should this month), but that causes an error with one of my txtboxes on the form its data control source is =Sum([Misc]) the qry doesnt retrurn anyrows so this give me a msgbox:
The microsof jet database engine does not recoginze 'misc' as a valid field name or expression.
misc would be an expense type from the xtab qry any help im in huge trbl
the cross tab qryr :
TRANSFORM Sum(qryRERaySelect.SumOfInvoiceAmount) AS SumOfSumOfInvoiceAmount
SELECT qryRERaySelect.Deal, Sum(qryRERaySelect.SumOfInvoiceAmount) AS [Total Of SumOfInvoiceAmount]
GROUP BY qryRERaySelect.Deal