Search results

....... 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

Many thanks one and all! (The database itself is a mixture of quotes in from suppliers, quotes out to customers, and all of the alternative part references used in quoting out the parts. Altogether it's a real mish mash of tables, reports and forms - which would take ages to try and get across)...

Hi many thanks for coming back... But my problem is how to pick the 100 records that are going to still make the forms and reports make sense and have data to pick up rather the there just being blank after blank. (There's a ton of reports, forms and data, and I haven't a clue how to cherry pick...

Evening! We have a database which has around 500,000 records on it, around a dozen tables, and half a dozen forms. I've been asked to get a sample of the database (comprising 100 or so records) that includes all of the structure from the tables, forms & records. Is there any way to do...

Thanks for coming back - you're spot on about how our customers feel about this: we'll leave that up to you to sort!!! We did suggest giving them template spreadsheets....and these were politely (???) declined!!!! :confused: Never mind, all's fair in love & war and trying to organise chaotic...

oops I meant to add in an example of our data! (and say we're using Access 2003) Manty thanks (again!!!):eek: