Charlotte Foust
charlotte.foust at gmail.com
Mon Jun 6 19:00:34 CDT 2011
Isn't this reinventing the wheel? An export spec should accomplish the same thing without having to process each value inidividually. Charlotte Foust On Mon, Jun 6, 2011 at 4:52 PM, Debbie <delam at zyterra.com> wrote: > When I needed to do this, I made a function that i passed the string and > the number of total chars needed. It would loop through until the length was > the number of chars and would add a space ( or in my case a 0) to the > beginning of the string. > > Debbie > > Sent from my iPhone > > On Jun 6, 2011, at 4:12 PM, "Brad Marks" <BradM at blackforestltd.com> wrote: > > We are using Access 2007 to create an output file for another firm. >> >> The specs for this file are dictated by the other firm. >> >> The specs call for numeric fields to be right justified and padded with >> spaces on the left. >> >> What is the best way to do this with Access 2007? >> >> Thanks, >> Brad >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> >> >> Website: http://www.databaseadvisors.com >> >> >> >> -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > >