I'm running a number of queries(select,append,delete,and maketable)from a macro. I turned of the warning messages by using:
Docmd.setwarnings=false
What I need to to is assign these procesed record numbers that appear in these warnings boxes to a variable.
I run my queries by using these...
When exporting a report the pdf option is not included in the drop down. Does anyone know the required crystal files needed for the pdf export option to be active.
I would help but your description of the report problem is confusing. If you still want help send me your report with the data saved.
jmorrison@second-foundation.com
Create two formulas:
Place the first in your group footer line:
WhilePrintingRecords;
numberVar Test ;
if Sum ({Encumbrance Amt}, {"Your group"}) <> 0 then
Test := Test + Sum ({ Expenditure Amt}, {"Your Group"})
Place the second in your report footer line...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.