Report with a cross query

  • 13 years ago


    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]), not part of the cross query

    Any other way to overcome this problem



Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The trouble with programmers is that you can never tell what a programmer is doing until it's too late.” - Seymour Cray