[AccessD] Counting multiple instances of a specific string

Drew Wutka DWUTKA at Marlow.com
Thu Aug 20 15:25:07 CDT 2009


I would recommend a design change on the interface Jeff.

Instead of having one text field, put the 'clocks' into their own table
(with IDs).

Ie:

1 - 2214
2 - 2410
3 - ENG

Then give them a listbox, to select the multiple clocks.  You could even
give them a single textbox to allow them to put in comma separated
values, and then have your own code go and split the values.

Record the data with another table (with the ID of the primary table,
and the ID of the clock table, so you will have multiple entries in that
third table, for each ID of the primary table, based on the data
entered).

Make sense?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Thursday, August 20, 2009 2:55 PM
To: accessd
Subject: [AccessD] Counting multiple instances of a specific string

I have a field, clocks, that can contain either three or four character
employee clock numbers.

The field can contain numbers (123 or 1234) OR text (ENG).

The field can contain one clock number or multiple clock numbers
(seperated
by a comma and a space).

The users claim that it HAS to be this way or they could be typing the
same
data multiple times with the only difference being the clock number.

Now, here is the problem.

They (Management) have decided that they need to be able to get a count
of
how many times the individual clock number appears in the table.

How do I check for multiple entries for a clock number when it could be
null, one clock number, or many clock numbers in one field?



Here is a sample of what the data looks like in the field:

*clocks***

2214, 2410, 2349, 2373, 2514, 2431

1537, 2296, 2202, 2212

2244

2411

2415, 2214, 2393

2431

2431, 1542, 2514, 1922

2431, 2214, 2516

2431, 2510, 2335

2410, 2202, 1170, 2212, 2431

2477

2410

2514

2516, 2397, 2422, 2296, ENG

2522, 2337, 1661, 2250, 1180




-- 
Jeff Barrows
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list