RE: acctsum.rpt

Erik Lundby ( (no email) )
Tue, 4 Mar 1997 22:53:09 -0600

Try running it from crystal reports and see if it gives you a more
descriptive error. I really don't know why it would give you an sql error.
I got that error from some of dales reports because they are for the
database emerald2 not emerald, but mine is for emerald.

-----Original Message-----
From: Jeffrey Betts [SMTP:jbetts@ccaccess.net]
Sent: Tuesday, March 04, 1997 10:06 PM
To: emerald@emerald.iea.com
Subject: Re: acctsum.rpt

I downloaded the acctsum.rpt installed it
in the registry everytime I try to run it I
get a SQL error . Can you help me with
what I am doing wrong ?

Thanks
Jeff Betts
Jbetts@ccaccess.net

----------
> From: Darren Klein <dmk@nwdc.com>
> To: emerald@emerald.iea.com
> Subject: acctsum.rpt
> Date: Tuesday, March 04, 1997 8:50 AM
>
> Hi,
>
> Who ever wrote the acctsum.rpt - Good job!
>
> But, can I ask you to make a revision.. can you not have it calculate
> expired accounts in the final total on the last page called 'Monthly
> Billables' ?
>
> Or, if someone can let me know how to modify the report to do this, I
> would appreciate it.
>
> Thanks.
> ------------------------------------------------------------------------
> | Darren Klein | Internet Service Provider | (718) 962-1725 |
> | dmk@nwdc.com | http://www.nwdc.com | (718) 962-1708 Fax |
> | New World Data Corp | | Telnet: nwdc.com |
> ------------------------------------------------------------------------
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com

----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com

begin 600 WINMAIL.DAT
M>)\^(@L$`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
MD 8`P $```$````0`````P``, (````+``\.``````(!_P\!````30``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````&5M97)A;&1 96UE<F%L9"YI96$N8V]M
M`%--5% `96UE<F%L9$!E;65R86QD+FEE82YC;VT`````'@`", $````%````
M4TU44 `````>``,P`0```!@```!E;65R86QD0&5M97)A;&0N:65A+F-O;0`#
M`!4,`0````,`_@\&````'@`!, $````:````)V5M97)A;&1 96UE<F%L9"YI
M96$N8V]M)P````(!"S !````'0```%--5% Z14U%4D%,1$!%345204Q$+DE%
M02Y#3TT``````P``.0`````+`$ Z`0```!X`]E\!````& ```&5M97)A;&1
M96UE<F%L9"YI96$N8V]M``(!]U\!````30````````"!*Q^DOJ,0&9UN`-T!
M#U0"`````&5M97)A;&1 96UE<F%L9"YI96$N8V]M`%--5% `96UE<F%L9$!E
M;65R86QD+FEE82YC;VT``````P#]7P$````#`/]?``````(!]@\!````! ``
M``````+I7P$$@ $`$ ```%)%.B!A8V-T<W5M+G)P= !E!0$%@ ,`#@```,T'
M`P`$`!8`-0`)``(`,0$!(( #``X```#-!P,`! `6`#$`( `"`$0!`0F `0`A
M````03)#040P.3A#-CDT1# Q,3E"-C@P,#0P,S,S,48V03D`!0<!`Y &`! (
M```A````"P`"``$````+`",```````,`)@``````"P`I```````#`"X`````
M``,`-@``````0 `Y`&!.>A\A*;P!'@!P``$````0````4D4Z(&%C8W1S=6TN
M<G!T``(!<0`!````%@````&\*2$>CYC0RJ.4QA'0FV@`0#,Q]JD``!X`'@P!
M`````P```$58```>`!\,`0```#D````O;SU3;V9T=V%R92!3;VQU=&EO;G,L
M($QT9"XO;W4]<W-L+V-N/5)E8VEP:65N=',O8VX]17)I:P`````#``80O>K+
M+@,`!Q >!0``'@`($ $```!E````5%)94E5.3DE.1TE41E)/34-265-404Q2
M15!/4E1304Y$4T5%249)5$=)5D5364]504U/4D5$15-#4DE05$E614524D]2
M25)%04Q,641/3E1+3D]75TA925173U5,1$=)5D593P`````"`0D0`0```-L$
M``#7! ``\P@``$Q:1G5[_M>&=P`*`0,!]R "I /C`@!C@F@*P'-E=# @!Q.'
M`H,`4 [V<')Q,@_V)GT*@ C((#L);S(U9C4"@ J!=6,`4 L#8P,`00M@;F<Q
M,#,S`0NF(%1R>2!R=69N`P`5<"!I!4 #4B"Y!0!Y<P&0`R )<' )$5,$( !P
M9" /L&47$&1%Q)G:78'D7D(8!B0=B $8 EP( $`!/09D2"#!) #8'(N("!)
M&!%5!T!L%H!D`B G!4!K9&YO!^!W:!: %R%W/0A@;!C &8(9U .@<W'3`R ;
M6&=O!4!T#X %0%L;4Q=$<P-P&0!O&3!DEP= !Y$8)F(%D&%U#[#]'[%E%H *
MP!D``A %P"*AJR$Q`9%A(G%E!X!R!T!>9!%P'- ?\214+"(0=7T%0&T+@!D!
M!" C,B1%+@\*H@J$"H0+,&QI,S:_`4 5$ % $4 ?D 60=!"$T#$V("TIXD\%
M$!F "FX7\4T'D'-A9V4_*>,G)BCT*,$+$RCV:2T8,30T`4 H0#$X,$<!0 S0
M+8-B($8#83IU#(-B#^!*`1$)<!: 0@,/P!AQ6U--5% ZYFHB(#!!0&,B0#%0
M*M'R+B8`=%TG)2ZP!F ",%4O%U0*4',A0'DE@$TC"L /<" P-"6 ,3E$.3<T
MH# Z,"G 4+)-,B=4;R\7)$5 )J8I")!A+@6@;3(H=6+&:BDA+Q=293H8D#%0
MX1AP=6TN<@4P*X\LFI\H1 NV)S,;T!Q@=VX)`/YA`0`8P"-R.@D7$ " %^'_
M(6 8P!<@)R0+@"-C"7 9@/L7T!9Q91F@%G ;`"#A&]#906)T;Q:2%Q)))R0K
M$&,%0!H@4U%,( 4;H$/G`Y$9XB*P;' :,!D``_#?'\ G)!T0'^$;T&$7@!Q@
M;1;B=P-@%O$_"N,G9E3Y#X!N:P] )S,OHC 4215?,/\ZIR="*>,K.3XNQ"!N
M1 K "7 #H$LA8$"A/ !D;6M ;G=D8_TW\CY-!C81-K\WRTU@.,9_.?]-44W@
M*1!2L#./-)4X/#HU#^$U=4U@309(:?(L5EY7:$*P0:)'8BD0(3Y_+2!';P1P
M(&KH;V(A5EY"); E@") <P.@1L%S:QG30J$`P&NK/J$8$78$`&D"("X;H']<
M<AGB)-(/@!LA%R$B0&P.8QV@5!%-!F5X<&G_"7%2P@A@`C $($"E+5 J@K]"
MH!?B`B C8PM@%] @"K"G*Q!?TC_B)TT"(6@<,-];IP,0"V "8 >0)T? 5E[_
M*C E@!DA(,("(&0B`Z A8/\EP1D`',-8D ?@75($< :0_T*!0.,80D*2'& ?
ML00`)8#G0T5-8!V$87 10 60!S#_64$7("<55KA(M&UW3&AP#^]Q'W(O<NE-
M!GQ-W'55='#^20(P!)%#P09A7A QD#503P-@7A $@71A*#<M\"FP(#DV,BUP
M`< U=83_<_A.RG58&[ 5`QV@14 "0.!P.B\O=WP`,=!/%9\HDQV@#^!UA7>Z
M,#@NP.QA>'C:!\)7!; =L50!OQH@"% Z@'K#@1]U9U1%8/\QX5*P>=EXYW+O
MA8^&GX>O/TS*30:$?XL/C!],CB!%[R14- $#$!;B3$%!@9HH0/\7T ^P=J $
MD%#/)SF*#Y.O_Y2_3(R./X]/D%^1;YJ=$@$"`)P@``,`$! ``````P`1$ ``
M```#`( 0_____T `!S#@LN6=("F\`4 `"##@LN6=("F\`0L``8 (( 8`````
M`, ```````!&``````.%`````````P`"@ @@!@``````P ```````$8`````
M$(4````````#``. "" &``````# ````````1@````!2A0``' X``!X`!( (
M( 8``````, ```````!&`````%2%```!````! ```#@N, `#``6 "" &````
M``# ````````1@`````!A0````````L`!H (( 8``````, ```````!&````
M``Z%`````````P`'@ @@!@``````P ```````$8`````$84````````#``B
M"" &``````# ````````1@`````8A0```````!X`"8 (( 8``````, `````
M``!&`````#:%```!`````0`````````>``J "" &``````# ````````1@``
M```WA0```0````$`````````'@`+@ @@!@``````P ```````$8`````.(4`
K``$````!`````````!X`/0`!````!0```%)%.B ``````P`--/TW``"C"X4`
`
end