General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only