Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. puttergirl

    Eliminate commas from beginning and end of strings

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

    Eliminate commas from beginning and end of strings

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

    Eliminate commas from beginning and end of strings

    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]))
  4. puttergirl

    Eliminate commas from beginning and end of strings

    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...
  5. puttergirl

    Eliminate commas from beginning and end of strings

    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?
  6. puttergirl

    Eliminate commas from beginning and end of strings

    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...
  7. puttergirl

    Eliminate commas from beginning and end of strings

    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...
  8. puttergirl

    Eliminate commas from beginning and end of strings

    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...
  9. puttergirl

    Help with dynamic crosstab query report

    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...
  10. puttergirl

    Help creating unique identifier reusing a range of numbers

    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...
  11. puttergirl

    Help creating unique identifier reusing a range of numbers

    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?
  12. puttergirl

    Help creating unique identifier reusing a range of numbers

    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...

Part and Inventory Search

Back
Top