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!

Register Log in
  • Congratulations Wanet Telecoms Ltd 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. rbuttens

    Excel Links in VBA

    I was hoping to use vba code to manipulate the links of excel workbooks. Can anyone point me in the right direction.
  2. rbuttens

    Problem linking Informix to MS Access via ODBC

    Hi, We have recently upgraded to informix v9 and to ODBC v 3.80. Now when I want to link to Informix through MS Access it only comes up with a list of shortened table names and the sql statements wont run at all. Has anyone come accross this problem before? Regards
  3. rbuttens

    'Renaming' Dimension Values in reports

    Cogprog, Further to my suggestion you could create a Max & Min Year object at design level. When you run query bring in the year object and also the max & min objects. Formula could then be:- if <year> = <Max Year> then &quot;Prior Year&quot; else &quot;Current Year&quot; This will work as...
  4. rbuttens

    'Renaming' Dimension Values in reports

    Cogprog, Need to use the following if statement which you can then define as a variable and use in place of the old one. if <year> = '2001' then &quot;Prior Year&quot; else &quot;Current Year&quot; rbuttens

Part and Inventory Search

Back
Top