Recent content by Hanna

....... although I would gladly send them over, I seem to have scoffed the lot. DRAT!!! PS Bullseye, old school PPS did *anybody* like a rhubard and custard?!!!!

Brilliant, I will have a play around - huge thanks Mr DB guy! And to you too Mr cheekybuddha .... the revised one works a charm Wow, this access stuff is amazing! I'm like a kid in a sweet shop haha

Hi gents, so appreciated! I seem to be able to get theDBguy's one running great (& it is probably my own fault that I can't get the other one giving the right looking results- sorrry!) Mind if I ask a question about the SQL query from the DBguy? ermmmmm can I tweak anything in the code so...

Hi, I'm trying to tidy up some data and ... as you may well spot(!) I'm pretty new to Access. I've got 1 table [called old] which has 2 fields: SKU_old and the associated drawing numbers: drawing_ref And the other table [called new] which 1 field: SKU_new I can see how to set up the...

Many thanks.......... I'll do some digging at this end and try to figure out where I'm going wrong. All the best

Thanks, I'm getting some unexpected results I'm afraid. Best Ellison

Hi, we are cleaning up some data. And to help us to identify patterns, we would like something that could [NB we will keep the original data, but update these results to a different field!] Change any letter a-z, A-Z to "L" Change any digits 0-9 to "9" Change any remaining characters such as...

I'll be honest I can't at the moment, but I'm going to do my damnedest to figure this out (bit by bit!).Thanks

Thanks for your help gents, after today's learning curve, I think I'm going to retire to a darkened room with a large whisky!!!

Thanks JDraw, is there enough info in the post above for you to unravel what I'm talking about??! (Although I'm pretty wet behind the ears when it comes to access, I've been working on Excel for a while. So by hook or by crook, I have been following your advice re: backing info up & making...

Gooooooooooooooosh I really am on a learning curve here!!!! Table Name: 99mfroutput Field Name with the original info: Reference_# Field where I was going to put the updated references: WIP Question1 (ahem!) of 2 To create the function, I did create Module: then should I change the text from...

Sorry, I should have pointed out that I've copied the references over so that we've kept the originals in a separate field. We deal in some pretty old, obscure product, and identifying these patterns (in conjunction with the other info on the report) is actually a good jumping off point for us...

The data that we have relates to part number references & their manufacturers. The manufacturers generally stick to common formats when they post part numbers. So if we were able to replace letters with L, and digits with @, then we could see which mfr's are using which formats EG ABCD-123...

Hi, we have a field of 7m records of varying length, some of which are numbers, some just letters, some alphanumeric, and most which include a dash, space or some sort of punctuation mark. We need to replace all letters with "L", then replace all digits with "@". We can replace characters...

That's brilliant one and all, many thanks for your help! :D