Search results for query: *

I think their site must be down as i can't access it either... thanks anyway, pete

Does anyone know any good sites for online SQL training? Thanks in advance, Pete

using excel 97, windows 95. thanks, pete

the euro symbols aren't inserted as the cells in question contain array formulae. if i insert a euro symbol it will (i assume) overwrite the formulae which is no good to me. i have formatted the cells that contain the formula as currency and changed the windows currency symbol to euros using...

Yes - I can't print the euro symbol from excel. But it is fine from word. I have changed the currency in control panel to Euro symbol and formatted the cells in question as currency. cheers, pete

Excel and Word 97 both display the Euro symbol on the screen, and in print preview but only Word seems to be able to print the Euro symbol. Which normally wouldn't be a problem but the company reports in euros! has anyone any ideas? thanks, Pete

It's live data in Excel (via SQL database link). And yes I can see the full field in both Crystal and Excel. Both excel and crystal are set to no decimal places. Pete

No it doesn't, it keeps datetime as datetime. the database in question however seems to default every time to midnight which may be the cause of this? Thanks for the help!

Does anyone know why when I do the following in Crystal : CurrentDateTime - {datetimefield} I get an answer that is one day less than the below in excel 97 : Now-{datetimefield} Any Answers/Ideas much appreciated, it's not causing me a huge problem it's just a bit perplexing. Thanks, Pete

Thanks for the site... i am sure it'll come in very handy at work! Pete

Paul, thanks for the suggestion, already tried that which is how i got the red ####... although i'm the first to admit i may have got the format slightly wrong. cheers, Pete

In column B I have a range of time in minutes and seconds (time format mm:ss.0) and the same in column C, Column D = C - B, if the answer is positive value then it formats fine, however if it is negative excel returns #############... I have even managed to get excel to turn the #### red...

sadly i can't get the user to drop the specification. thanks for your help, i'll give it a bash. cheers, pete.

I have been using SCR formulas/subtotals for the claculation.

Hi - hoping for help... I have account names in one column and their revenue for the last 365 days next to it, it is then rated (A,B,C,D) according to which quartile it falls into. next to that I have the revenue genrated by that account for 365 to 730 days. How can I get crystal to calculate...