include only text with >1 character

  • Thread starter Thread starter Jeff Gil
  • Start date Start date
J

Jeff Gil

I would like to report text data entrys by customer
service reps that are made into the database that only
contain more that 1 character and do not contain
only "spaces". We are counting the entrys made into the
database for each rep and those with an accidental space
or meaningless text with only one character are currently
being displayed and counted. How can I limit the report
to only display entrys that contain a text field with more
that one text character or don't have only "spaces" typed
in?
thanks
JG
 
You could use the following expression in a test:

Len(Replace(Nz([FieldName], ""), " ", "", 1, -1, 1)) > 1
 
Thanks- I used the Len() function to count all characters
and then limit the query to count ">1". I do not have
a "replace" or "nz" function that you showed in the
formula. JG
-----Original Message-----
You could use the following expression in a test:

Len(Replace(Nz([FieldName], ""), " ", "", 1, -1, 1))
1


--

Ken Snell
<MS ACCESS MVP>

I would like to report text data entrys by customer
service reps that are made into the database that only
contain more that 1 character and do not contain
only "spaces". We are counting the entrys made into the
database for each rep and those with an accidental space
or meaningless text with only one character are currently
being displayed and counted. How can I limit the report
to only display entrys that contain a text field with more
that one text character or don't have only "spaces" typed
in?
thanks
JG
Click to expand...


.
Click to expand...
 
Jeff said:
I would like to report text data entrys by customer
service reps that are made into the database that only
contain more that 1 character and do not contain
only "spaces". We are counting the entrys made into the
database for each rep and those with an accidental space
or meaningless text with only one character are currently
being displayed and counted. How can I limit the report
to only display entrys that contain a text field with more
that one text character or don't have only "spaces" typed
in?
Click to expand...


Another way is:

Len(Trim(FieldName)) > 1
 
Nz is an ACCESS VBA function that is avaiable to queries. Replace is
available in queries for ACCESS 2002 and higher, or in ACCESS 2000 if you
have at least SP6 of Jet 4.

--

Ken Snell
<MS ACCESS MVP>

Jeff G said:
Thanks- I used the Len() function to count all characters
and then limit the query to count ">1". I do not have
a "replace" or "nz" function that you showed in the
formula. JG
-----Original Message-----
You could use the following expression in a test:

Len(Replace(Nz([FieldName], ""), " ", "", 1, -1, 1))
1


--

Ken Snell
<MS ACCESS MVP>

I would like to report text data entrys by customer
service reps that are made into the database that only
contain more that 1 character and do not contain
only "spaces". We are counting the entrys made into the
database for each rep and those with an accidental space
or meaningless text with only one character are currently
being displayed and counted. How can I limit the report
to only display entrys that contain a text field with more
that one text character or don't have only "spaces" typed
in?
thanks
JG
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top