Search results for query: *

I'm using Excel 2003 and Edit -> Links is greyed out. Is there another way of viewing files linked to the spreadsheet? And also editing the files linked? I already know that the file I'm working with is linked to an Access database (also 2003). Any help gratefully appreciated

Thanks George, I've amended the code to take this into account.

Makes sense and works really well!! Ta v much

I'm not a complete newbie to SQL, but I've reached the limit of what I can do with the query I'm working on. What I need to do is bring back the rows of data where one of the 12 fields I'm checking contain the codes I'm looking for. Here's how I've declared my variable (this is cut down)...

Cheers Brian, wasn't quite what was needed, but got me on the right track! dgillz, I suggested that initially to my colleague, and since he had already converted the number to text, it seemed easier to get rid of the thousand separator afterwards. As it turns out, I had to do the 2 hour drive...

Hi! My collegue is trying to remove a ',' from the output of the following: if {EComp.EmAnnual} < 10.00 then '000000' + (totext({EComp.EmAnnual})) + '0' where {EComp.EmAnnual} is a number field and the ',' is thousand separator. He's using Crystal 7, and says that the following doesn't...

[2thumbsup] Thank you both!! Both parameters have been passed back to the subreport sucessfully! :-D Cheers Hetal

[thumbsup] Cheers LB, I'll give that a go. And yes the same record selection formula is in the subreport also. Hetal

Hi! I'm using Crystal 8.5. I need to pass a string parameter from the main report to the subreport. The manin report (in the Group Footer #1) is essentially a summary report of a business process, the subreport is exactly the same but a different view of the data. The subreport has been...

Thanx ^_^ That worked a treat

Help! I'm trying to write a report that shows the forename, and surname for a person (along with other relevant data, which I already have sorted out). The table (people) has 4 fields that may contain this information; Forename, Surname, Legal_forename, Legal_Surname. If the Forename field...

Unfortunately, Crystal doesn't let you specify which print tray you wan your printout to come from. I've found that Crystal will use the default printer settings for the PC you're working from.