Search results for query: *

Perfect Thanks for you help Joanne

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

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

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

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

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

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

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

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

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.

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