Search results for query: *

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

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.

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

My example does not have any blanks in it. some of the results of my attempt to convert had blanks (really = #error in access). Using Expr1: CDate(nz([Date Entered],Format(Date(),"mm/dd/yy")) & "" & nz([time Entered],"00:00:00")) yields #error in Expr1 column...

Thank you, Ken. I tried (or hoped I tried) what you suggested. It's doing something, but, not what I was hoping for. I added new field to my query: Expr1: CDate([Date Removed] & "" & [Time Removed]) Result is in the 3rd column below. It did combine the 2 fields, but, not...

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

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