Search results

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

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

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

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

Hi, we have an issue which we think Access can help dig us out of :banghead: …. arrgghhhhh!!! Sorry, had to get that off my chest :-) Effectively, we sell washers & we have to run through a dozen or so monthly reports (that our customers send us) to work out a) forecasts for the production...