Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: GOING ON Vaction NEED HELP ASAP

    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]
    FROM qryRERaySelect
    GROUP BY qryRERaySelect.Deal
    PIVOT qryRERaySelect.ExpenseType;

  2. #2
    Join Date
    Oct 2003
    solution was simple enter a record for 0.00 so the qry returns 0 instead of null

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts