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 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: jmfox2
  • Content: Threads
  • Order by date
  1. jmfox2

    get rid of seconds in display

    trying to create field that looks like: 1500(12.5) to represent start shift time and the duration of the shift. I have shiftstartdate shiftstarttime, shiftenddate, shiftendtime that are datetime fields. hour(shiftstarttime) &"("& datediff('h',shiftstarttime,shiftendtime) getting...
  2. jmfox2

    split data field with '/' as deliminter in data

    field value="level1/level2/level3/level4" i need to be able to create separate fields for each of the levels. field1="level1" field2="level2" field3="level3" field4="level4" thanks. used to do CR alot, 5 year lapse and I find myself a little more than rusty.
  3. jmfox2

    Problem with sorts in graph

    I have a graph that is not sorting the graph variables correctly. The data is grouped by location, department and category with additional sort on fiscal year/period (ie: 200301 text field). Graphs look good until the non-grouped sort field fiscal year/period. The data comes out looking like...
  4. jmfox2

    Converting text fields to date/time

    I have a date field and a separate text field that contains the time. Date Entered time Entered Date Removed Time Removed 12/18/02 0700 8/27/02 1200 12/4/02 1600 7/13/02 700 12/4/02 1300 7/3/02 1000 12/4/02 2400 7/17/02 1100...
  5. jmfox2

    using selective summary data to do percentage

    I am working with data like this (minus the %change col). The data below are summarized groups within my crystal. DRG fy fyfq Cases AChrgs % change level1 99999 2001 200101 33 8,584 99999 2001 200102 32 7,825 99999 2001 200103 43 7,491 level2 99999 2001 Tot 43 7,924 level1 99999...

Part and Inventory Search

Back
Top