Search results for query: *

Sounds fair enough to me... Thank you for all your help. I'll let you know how i go. BJ

Thanks Mufasa! This looks great... but... now i lose finding the max absolute values for each date. Is it possible to work this aspect into the query as well? Thanks so much for your help.

sorry for my ignorance, but i'm not sure i understand where this sub query fits into the query i already have... can you provide more assistance? thank you :)

How would i go about converting this: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000 -9.0 37 2003-12-13 00:56:44.000 117.0 to this: xddatetime tilt54 pitch55 2003-12-13 00:56:43.000 -199.0 -9.0 2003-12-13 00:56:44.000 117.0 where...

sorry... i have another question! How would i go about converting this: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000 -9.0 37 2003-12-13 00:56:44.000 117.0 to this: xddatetime tilt54 pitch55 2003-12-13 00:56:43.000 -199.0 -9.0...

This works!!! Thank you so much for your help... Keep up the good work. Thanks heaps, B

i would like to find the max absolute value for each distinct sensorid and datetime. And then i want to be able to show these values in their original form, i.e whether they are positive or negative. there will be many entries for sensor id 54 and 55, but at different times throughout the day...

hi mufasa, i tried your suggestion and came up with this query: select xdsensorid, xddatetime, xdvalue, xdlongitude, xdlatitude from his_externaldata where abs(xdvalue) = (select max(abs(xdvalue)) from ((vmi_vehicles inner join ext_sensors on vunitid = sunitid) inner join...

Hi This is the original data: 37 2003-12-13 00:56:43.000 -199.0 37 2003-12-13 00:56:43.000 -156.0 38 2003-12-13 00:56:43.000 -9.0 38 2003-12-13 00:56:43.000 3.0 37 2003-12-13 00:56:44.000 117.0 What i would like to see some how is: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000...

hi there! i have a bar chart which graphs the time a vehicle has spent at a specified location. At the moment i can only figure out how to display the data values as 20.45 (20 hours and 45 minutes) - i would like to display it as 20:45. Is this possible??? Thanks, B

Hi All, This is what i have got so far: declare @ThisDate datetime create table #DayList (FakeDate datetime) set @ThisDate = '08/17/2003 14:00:00' while not( (round(convert(float,@ThisDate),0,1) )> (round(convert(float, convert(datetime,'08/19/2003 13:59:59')),0,1)) ) begin insert #DayList...

Hi All, This is what i have got so far: declare @ThisDate datetime create table #DayList (FakeDate datetime) set @ThisDate = '08/17/2003 14:00:00' while not( (round(convert(float,@ThisDate),0,1) )> (round(convert(float, convert(datetime,'08/19/2003 13:59:59')),0,1)) ) begin insert #DayList...

i have solved this by using this formula in the suppress section. whileprintingrecords; Local numbervar ONE_MIN := 1 / (60 * 24); if {@VisitLength} < ONE_MIN * ({?Visitminimum} - 0.01)then true thank for all your help :)

hi all, this is what i want to achieve: (Location) (From) (To) (Visit Length) 1/5/03 XXXXXX 00:00 07:30 07:30 XXXXXX 08:16 17:31 09:15 XXXXXX 18:02 00:00 05:58 2/5/03 XXXXXX 00:00 07:00 07:00 XXXXXX 08:37 17:31...

if i use this formula in the suppress section: Whileprintingrecords; if {@DisplayVisitLength} <= totext(truncate({?VisitMinimum}),&quot;00&quot;)&&quot;:&quot;& totext(val(right(totext({?VisitMinimum},2),3))*60,0) then true it says 'a time is required here' - the cursor is in front of...

this is what i am puting in the suppress section (it didn't work in the group select): Whileprintingrecords; if {@VisitLength} <= totext(truncate({?VisitMinimum}),&quot;00&quot;)&&quot;:&quot;& totext(val(right(totext({?VisitMinimum},2),3))*60,0) then true and it says 'a number is required...

i tried the above suggestion - but it asked for a number??? this is what i have tried and works for some cases and not others. Local numbervar ONE_MIN := 1 / (60 * 24); if {@VisitLength} < ONE_MIN * {?Visitmin} then //suppress visit length less than minimum true the only time it doesn't...

i tried this: {@BreakDuration} > {@DisplayVisitMinimum} where {@DisplayVisitMinimum} is ToText({?MinVisitLength},0) + &quot; min&quot; + iif({?MinVisitLength}<>1,&quot;s&quot;,&quot;&quot;) and it came up with this error: 'This formula cannot be used because it must be evaluated later' Any...

Here is the contents of VisitDuration: @VisitDuration is available in the group selection - do i need to add the formula there? Shared numbervar TotalBreaks; local Stringvar HoursText; local StringVar MinsText; local StringVar SecsText; local numbervar nHours; local numbervar nMinutes; local...

I don't seem to be able to do this because the @VisitDuration isn't in the selection formula list. Why would it not be in there? Thanks, B