text and number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

We have created a table and a form to track all of the clients informations
coming into the business.

Then, we categories the clients into five different types and assigned
number with each one of the clients. For example:

Ca01, Ca02, Ca99

WC01, WC02...WC99

MC01, MC02, MC99

On the form, we assigned text to these client identifications. But because
they are text and number, we ran into a problems in having the form showed
the last client identification. When we have more than 99 clients into each
categories. The form doesn't show CA100 or WC100.

Your help is appreciated.

Al
 
You will have to explain more fully. Where to the numbers come from? Is your
column big enough to show the extra digit. E.g. if you defined the column as
length 4, you could not store CA100.

Dorian
 
It generally best to stay away from "smart" numbers like you have here. If
you want to categorize clients, create a seperate column that indicates the
client category. This way, your client numbers would be sequential regardless
of their category and the client id field could be numeric.

Barry
 
Allen

I'm not too clear on how your data is structured. Are you saying that you
have multiple fields with "repeating names" like Ca01, Ca02, ... Ca99? Or
are these the unique row identifiers for your clients?

What about the "WC01..." and "MC01..." values? Keys or fieldnames?

More info, please

Jeff Boyce
Microsoft Office/Access MVP
 
Thank you for your response. WE ran into problem when these each individual
category of clients comes in. Ca99 stands for clients whom paid cash and
number 99. Wc99means clients with worker's compensation case number 99. e We
have clients more than 99. But filed is only showing to 99 for all
categories of clients.

We have text as the format type. But it always show up to 99, but not
clients whith Ca 101, Wc 101, Mc101. Is there any other format besides text
format? Thanks for your input.

Al
 
Thank you for your response. WE ran into problem when these each individual
category of clients comes in. Ca99 stands for clients whom paid cash and
number 99. Wc99means clients with worker's compensation case number 99. e We
have clients more than 99. But filed is only showing to 99 for all
categories of clients.

We have text as the format type. But it always show up to 99, but not
clients whith Ca 101, Wc 101, Mc101. Is there any other format besides text
format? Thanks for your input.
Click to expand...

It sounds like your problem is that you're improperly storing two
distinct pieces of information in one field. You might want to
consider having one field for the client type (with values Cash, WC,
and so on) and a separate Integer field that you would increment using
VBA code on the Form you use to enter your data (no, you cannot do
this in a Table, you do need a Form).

You can concatenate the two fields for display purposes, but they
should not be stored in one field.

John W. Vinson[MVP]
 
Back
Top