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!

  • Congratulations biv343 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. jo65uk

    Joining rows in a group together

    Perfect Thanks for you help Joanne
  2. jo65uk

    Joining rows in a group together

    Can I do anything about the length "10" as they are all different Joanne
  3. jo65uk

    Joining rows in a group together

    If {drug_basic.drugname}like 'HOMECARE-*, CIVAS -*, CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname} else If {drug_basic.drugname}like 'CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname} I get the message - The remaining text does not a ppear to be...
  4. jo65uk

    Joining rows in a group together

    If {drug_basic.drugname}like 'HOMECARE-*, CIVAS -*, CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname} else If {drug_basic.drugname}like 'CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname} I get the message - The remaining text does not a ppear to be...
  5. jo65uk

    Joining rows in a group together

    I have used this formula If Fieldname like 'HOMECARE-*' then mid(Fieldname, 10, 50) else Fieldname I would like to do this for multiple prefixes If Fieldname like 'HOMECARE-*, CIVAS-*' then mid(Fieldname, 10, 50) else Fieldname but this doesn't work Any ideas? Joanne
  6. jo65uk

    Joining rows in a group together

    Group on formula @Group If Fieldname like 'HOMECARE-*' then mid(Fieldname, 10, 50) else Fieldname Change 50 for max length of fields, if name not that long dont worry formula will only bring back what is there. Ian This worked fine Thank you Joanne
  7. jo65uk

    Joining rows in a group together

    Yes there will always be a dash, but there may be other maedicines with a dash in. The unique identifier to these rows is the prefix HOMECARE- The field name is drug_basic.name
  8. jo65uk

    Joining rows in a group together

    Thanks for the reply The data is always prefixed by the word homecare- So the data looks like Homecare-apple Apple Homecare-banana Banana The actual data is medicines but didn't want to lists meds in a post
  9. jo65uk

    Joining rows in a group together

    I have a report with the field fruit.basic.name which produces a list of fruits and how much has been sold, as below. I would like to merge alike rows Red apples. 12.57 Green apples. 8.76 Large bananas 4.56 Small bananas 3.47 Long bananas 1.34 I would like it to look like this Apples...
  10. jo65uk

    Frontpage freezes and get error message"system resources dangerously "

    Just to let u know I have found the answer - Find and delete the cmdui.prf file for FrontPage - this is the file that stores your customizations and preferences for the FrontPage Menu and it will get rebuilt, using the defaults, the next time you start FrontPage.
  11. jo65uk

    Frontpage freezes and get error message"system resources dangerously "

    When I try to open files in Microsoft Frontpage, the system starts loading, then it won't finish. When trying to end task, system brings up white text box that states "System is dangerously low in resources." I have seen replies on this forum about the same problem in word and you...

Part and Inventory Search

Back
Top