Search results for query: *

Thanks, TheAceMan1. It was the field the string went into but I've got it now. Thanks.

THANKS, THANKS, THANKS everyone. That one worked. You're life savers!!!!

I've tried this but its not working: [Forms]![Laboratory License]![CLINICAL CHEMISTRY] = IIf(IsNull([Forms]![Laboratory License- Cats2]![Astr]), "", RemoveCommas([Forms]![Laboratory License- Cats2]![Astr]))

Softhemc, you're right. I know I have a problem at the point that the string is saving to the table. But right now I've created such a complicated program with the string coming from so many sources, I don't want to take a chance of breaking anything. At least for now I want to be able to get...

Thanks, both of you. Both of these work great except they won't handle the null fields. I tried to put them within an IIF statement but I'm having trouble with that too. Any suggestions?

Bottom line is... I need a function that will fix all kinds of comma errors so that the finished product contains only 1 comma and space after each value. So it will take a cell like this: , ROUTINE, , , TOXICOLOGY, TCM , OTHER (URINALYSIS), and turn it into this: ROUTINE, TOXICOLOGY, TCM...

Thanks to both of you. I love both. I'm not good at writing code. Could one of you please help me combine statements into 1 module. First, I want it to take any multiple commas and change it to just 1, such as: ROUTINE, , , TOXICOLOGY I had written a function: Replace([CLINICAL...

I have a form set up where you select many items from a list and when you save it, it transfers the values into one field on another form separated by commas. Sometimes after changes, I end up with commas at the beginning or end of the string. I would like a function that would remove the...

I'm creating a report using the code in this article: http://support.microsoft.com/kb/328320 My crosstab query looks like this: TRANSFORM First([2 yr hx].[S/S]) AS [FirstOfS/S] SELECT [2 yr hx].EXIT_DATE AS [EXIT DATE], Count([2 yr hx].[S/S]) AS CITATIONS FROM [2 yr hx] GROUP BY [2 yr...

Thanks for your help! There are only 1000 machines max in each county. We have to use the following ranges to specify which type of machine it is: 0000-0999- Medical 1000-1999- Hospital 2000-2999- Dental .... etc We actually reach 1000 in the large ones within about a year. People with...

How do I handle the range of numbers? If they reach the top of the range for a machine type, I need the numbering to start over, except with a new letter tacked on to the end?

HELP me; I'm really stuck. I need to create license numbers for Xray machines based on the county and type of machine. The number will have 3 parts- a county code followed by a dash, then a 4 digit number within a range depending on machine type, and then a distinguishing letter at the end to...