Can I "zero fill" a field result 10

[dieselBREATH]

In Access 2000, I have a field that results in both alpha characters and numeric. Ex:

erf55667.77
345676
2345.66
jfhhh334343

How to keep only the numbers, make the field a fixed length and return zeros where there are no numbers? Some refer to this as zero-fill.

Thanks for anyones help

 

[dieselBREATH]

Sounds like we need to get our heads together and find Michael a job!!

At this point, I would like to at least have your guys contact information so that I might call upon you when I have jobs that require your services.

By the way, burried deep into this thread is a request I made for learning VB and DB ( SQL ). Any thoughts on any good resources for a beginner? (by now you all know how much of a beginner I am!)

Diesel

 

[THoey]

DB, sorry for the digression. But, you wanna know probably the best way to start picking up SQL and VB? Read every thread here when you have time. There is soooo much that I have learned here either by trying to help someone or just by lurking. The questions in this forum and the other Access forums are various to say the least. Better than paying for training or following some scripted tutorial. Terry M. Hoey

 

[MichaelRed]

My local community college is synonomous with the local discout book seller (Boarders?). I - personally - like the Que and Sybex series for MOST of the IT topics.

The Help systems are really quite good, but suffer the same 'fault' as the average distionary (" ... If I knew how to spell it I WOULDN'T need to look it up ... &quot - so you need to know what to look for before looking for it. But works well for syntax and SOME of the examples are actually useful. To use the help / examples, you need to carefully understand the legaleese 'mind set' of the process, so where is says string it REALLY means literal QUOTED string, while string or string variable means the other ... and so on. I - personally - think MS Access is easier to learn, as VB requires you to not only learn VB / VBA, but even to get started with db manipulation you also need to get in to connectivity issues and decisions on wheather to use bound or unbound controls AND the BIGGIE - how in the real world you will generate reports (or most any printed output). Other than these issues, you can learn VB/A in either and almost universally apply that knowlege to the other.

I have the perception that many supposedly "professional" IT types think of MS Access as the lowest level of programming possible, with VB being a LARGE step up the chain. However I have used both (commercially) and really see almost NO difference in terms of VB/VBA. The trend - from my perspective - is that they are strongly convergent. If they ever actually become 'one', I really hpe the MS Access report generator AND the VB access to the printer object(s) are both retained.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[ChrisBurch]

I'm also new to Access, and having done a lot of 'lurking', as Terry puts it, and am starting to learn (albeit slowly). Michael gets a star from me for the major assistance given to DB.

DB. I've just orderered 'Access 97 Macro & VBA Handbook' by Susann Novalis. I'm hoping that this will bridge the gap between where I am now, and the Access Developers set (which is Waaaaaaaay over my head at this time). I'll post if I feel that it is a newbie suitable book.

 

[dieselBREATH]

Congrats Go to Michael for man of the week. Think my thread had anything to do with it??

DieselBreath

 

[Databaseguy]

>>I have the perception that many supposedly &quot;professional&quot; IT types think of MS Access as the lowest level of programming possible, with VB being a LARGE step up the chain. <<<

No doubt !!!! I tell people I program Access & it's like, &quot;Oh, that's not a REAL program....&quot;

 

[MichaelRed]

dieselBREATH,

with 5 (FIVE) stars it had &quot;EVERYTHING&quot; to do with it.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[THoey]

Michael, I am pretty sure you got more than five. It was at five and then I saw another post that the person stated giving you a star...

But either way, a well deserved congrats... Terry M. Hoey