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.