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 bkrike 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: *

  • Users: gilsonr
  • Content: Threads
  • Order by date
  1. gilsonr

    Enterprise Miner

    I have SAS 8.2 running under Windows XP home edition. But when I open up Enterprise miner it does not display correctly, therfore is there a compatability issue.
  2. gilsonr

    Using a formula in a if then else statement

    I have created the folloing if then else statement in a formula field if status = "86" then "Live" else if status = "87" then "Live" else if status = "88" then "Live" else if status = "89" then "Live" else if status = "90" then "Live" else if status = "91" then "Archive" else if status = "97"...
  3. gilsonr

    Extracting Month from current date

    How do I extract the Month name (i.e. March) form the current date.
  4. gilsonr

    Cross- Tab Total field

    I have created a report which just contains a Cross-tab. The problem is that the values are OK, and the column totals are OK, its just the row total that are not correct. Any suggestions would be appreciated.
  5. gilsonr

    Business Objects Grand Total

    This is probably a really basic question, but how do I add a Grand Total to a Report
  6. gilsonr

    Access 2000 Electronic Signature

    I am trying to add an authorisation field to the bottom of an Access Form. As the database is to be used for authorising Purchase Orders within the Finance department, I need to add some sort of 'Electronic Signature' to the authorisation field. This will used to track and audit who has signed...
  7. gilsonr

    Date Problem

    I am running a query against an Oracle database that stores dates in the following format 23SEP2004:00:00:00. When I try to select records for an specific day, in a where clause I dont get the correct results. I am using the Datepart function to get rid of the Hr:mm:ss. Any ideas
  8. gilsonr

    Record selection

    I need to select records based on the follwoing criteria Job type not equal to cancelled and Mailing date between X and Y and Completion date is null or Job type not equal to cancelled and Calldate1 between X and Y and Completion date is null or Job type not equal to cancelled and...
  9. gilsonr

    Using Parameters in Crosstabs

    Is it possible to use a date range parameter to controll a cross-tab report, if the cross-tab is in the report header.
  10. gilsonr

    Number Date Conversion

    I have a Date field which is displayed as a series of numbers i.e. 200203051200310, and I want to convert this to a date field. Attached is the formula that I have been using to convert the number to a date. CDate(Mid([dbo_options]![LAST_UPDATE_MINI],7,2) & "/" &...

Part and Inventory Search

Back
Top