<div dir="ltr"><div>Okay - I got it all working -- thanks for all your guys input</div><div>much appreciated</div><div> </div><div>Scott</div><div>PDM</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 5:38 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <span dir="ltr"><<a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Yes....if I don't use ",g" then aa is always blank, when put in the subtotal section of the output format.....if I use ",g" then aa is always equal to ab -- so in the instance of client 5499, aa and ab are both 0091</div>
<div>..and I thought you said 'not' to use ",g" ?</div><div>So aa should be (4,#,g)? Only aa should be ",g"? Not ab?</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Mon, Jul 14, 2014 at 5:34 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote"><div>On 7/14/2014 4:59 PM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
Yes that's what it said - so I did as you said and yes, in fact the beep<br>
msgbox only is encountered once - thanks now line 1 is blank in the If:<br>
and Then: end<br>
Now if I can just figure out why aa is always blank then I'll be<br>
set.....thanks for that tip....<br>
</blockquote>
<br></div>
You keep saying that aa is blank when you don't have ",g", but that it has a value when using the required ",g".<span><font color="#888888"><br>
<br>
-- <br>
Kenneth Brody<br>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br></div>