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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jhowardcarter

  1. jhowardcarter

    Exporting from Crystal XI to ODBC - Date/Time value

    Hi, When exporting a date/time value (style: system default short format) from crystal to a SQL table (which by default creates a new table), I'm loosing the seconds value of the date time. eg 28/07/2009 09:01:13 becomes 28/07/2009 09:01:00. When crystal creates the table, and the field...
  2. jhowardcarter

    Labelling data within Cross-Tab

    Hi Adam, Of course I can share .. Within the cross-tab expert, third tab 'Customize Style', sub-section 'Summarized Fields; there is an option to include lables (Show Labels). There are also a few formatting options as to where these are displayed. Kinda wished I'd looked harder before...
  3. jhowardcarter

    Labelling data within Cross-Tab

    Solution found - - thanks for reviewing my post J
  4. jhowardcarter

    Labelling data within Cross-Tab

    Hi, I have a cross tab with three datasets within the 'summarized fields' section (these relate to a positive, negative and no result received). These all output a summed numeric value. There is one 'Row' item (type) and one 'Column' item (calander day 1 to 30). I'd like to label the +ve, -ve...
  5. jhowardcarter

    time difference formaula

    Thanks Ian, perfect. Have a good day.
  6. jhowardcarter

    time difference formaula

    Hi, Newbie .. simple one .. I hope. I have 2 date/time stamps(start time:x, end time:y). I need to show the result of a formula calculating the different between these date/times (y - x) in the format of date/time ... Can i find it anywhere ..? Thanks, in advance.
  7. jhowardcarter

    running total - cumulative data

    hi, i have numerical data relating to the calandar day in the month. I need to display this data with calalandar date moving down the rows and two columns relating to the data for that day and a running month to date total, which will increase moving down the rows. this data will then be...
  8. jhowardcarter

    SQL - select and delete query - clean data not matching criteria

    Hi, Within a table (dbo.accounts) of over 190k records, I have an email address field (varchar(50), null), within which is all sorts of data (most not email addresses). I'm looking for a method the clear the data within the field which is not an email address, and return this to a NULL value...
  9. jhowardcarter

    calculate working days in a month

    Hi, How could I calculate the number of working days in a month (monday to friday, excluding weekends). Also I'd need to return the current working day. I appreciate this may not be exact allowing for B/Hols's etc. Thanks, jmhc
  10. jhowardcarter

    Dual Summarising Date/Time data

    Hi LB, Spot on - thanks. I'll post correctly next time. Cheers
  11. jhowardcarter

    Dual Summarising Date/Time data

    edit - I'm summarising data related to the date/time stamp which is a numerical value (not summarising the actual date time stamp) JC

Part and Inventory Search

Back
Top