Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Mike,
I've got a report that i'm listing the totals of the records that have certain criteria (given by the user). That part prints fine, but at the bottom, I also need these totals totaled. That is what the code is supposed to do.
The error is that "the variable 'total' could not be found". total is actually a cursorname, and it's the records in 'total' that I need summed and used in my report.
>Hi Jimmy,
>
>>What's wrong with this statement?
>
>First you've got to tell us what is happening and what should happen. Errors? One guess could be that "siz = pcValue" size is spellt wrong. Also try adding the alias to siz and alltrim pcValue before hand.
>
>>I'm trying to gather all data in the field data1.total, sum it, give it a variable reference, and use it in a report.
>
>Variable note: You don't need these as public variables. Private or even Local will work.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement