Report with a cross query

• • Reply

  13 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 years ago

  Hi,

  I need an advice in one report that uses a cross query table...I want to sum the fields that do the pivot.

  I passed the parameters by Querydef in the form and the report uses the cross query as a source

   Access gives a msg error that the Independant field (Sum[Txt1]) , (Sum([Txt2]),.....is not part of the cross query

  Any other way to overcome this problem

   

  Thanks

  Report abuse