How do I could characters in a field?

  • Thread starter Thread starter Russell Farr
  • Start date Start date
R

Russell Farr

Hi

Does anyone know how I can take a field, and count how
many characters are in it using some form of code? Or is
there some Access function I can use?

What I'm trying to do is get my database to import a
spreadsheet and 'clean' it up before then appending it to
an existing table.

I'm importing to a temporary table, running a series of
queries which chop and change the data, but I also need to
validate the data in one particular field so that I can
prompt for user input when the field is over 8 characters.

Thanks for your help

Russell
 
Russell, your idea of importing into a temp. table for massaging is very
useful.

After import, could you not just present the user with a list of the records
from the temp table that need their attention? The query would be:
SELECT * FROM MyTempTable WHERE Len([MyField] > 8;
 
Thanks for this Allen. I think I can use this!

Cheers

Russell
-----Original Message-----
Russell, your idea of importing into a temp. table for massaging is very
useful.

After import, could you not just present the user with a list of the records
from the temp table that need their attention? The query would be:
SELECT * FROM MyTempTable WHERE Len([MyField] > 8;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Russell Farr said:
Does anyone know how I can take a field, and count how
many characters are in it using some form of code? Or is
there some Access function I can use?

What I'm trying to do is get my database to import a
spreadsheet and 'clean' it up before then appending it to
an existing table.

I'm importing to a temporary table, running a series of
queries which chop and change the data, but I also need to
validate the data in one particular field so that I can
prompt for user input when the field is over 8 characters.

Thanks for your help

Russell
Click to expand...


.
Click to expand...
 
Back
Top