include only text with >1 character

[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

 

[Ken Snell [MVP]]

You could use the following expression in a test:

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

 

[Jeff G]

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

.

 

[Marshall Barton]

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?

Another way is:

Len(Trim(FieldName)) > 1

 

[Ken Snell [MVP]]

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>

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

.