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

    Excel 2003 - View Linked files

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

    Declaring variables

    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)...
  3. cafenerogal

    Alternative to Replace?

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

    Passing Parameters to a subreport

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

    Counting characters in a string

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

Part and Inventory Search

Back
Top