<div dir="ltr"><div>I made aa & ab ",g" -- which I swear I did yesterday and it didn't work....so not exactly sure, but I guess that had to be it.....guess I was brain dead yesterday or something....</div>
<div>thanks again</div><div> </div><div>Scott</div><div> </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jul 15, 2014 at 9:55 AM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On 7/15/2014 9:03 AM, <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">
Okay - I got it all working -- thanks for all your guys input<br>
much appreciated<br>
</blockquote>
<br></div>
What changes did you make so that aa had the correct value?<div class="HOEnZb"><div class="h5"><br>
<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">
<br>
Scott<br>
PDM<br>
<br>
<br>
On Mon, Jul 14, 2014 at 5:38 PM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> <<a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>><br>
wrote:<br>
<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....if I don't use ",g" then aa is always blank, when put in the<br>
subtotal section of the output format.....if I use ",g" then aa is always<br>
equal to ab -- so in the instance of client 5499, aa and ab are both 0091<br>
..and I thought you said 'not' to use ",g" ?<br>
So aa should be (4,#,g)? Only aa should be ",g"? Not ab?<br>
<br>
<br>
On Mon, Jul 14, 2014 at 5:34 PM, Kenneth Brody <<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>><br>
wrote:<br>
<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">
On 7/14/2014 4:59 PM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<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>
<br>
</blockquote>
<br>
You keep saying that aa is blank when you don't have ",g", but that it<br>
has a value when using the required ",g".<br>
</blockquote></blockquote></blockquote>
<br>
-- <br>
Kenneth Brody<br>
</div></div></blockquote></div><br></div>