Search results for query: *

LB, many thanks for all your help!

The calculations are correct as the expressions are currently written. I suppose I could change them, but as long as they're working, I'm inclined to leave them alone. What do you think? Here is a sample report (which uses formulas to convert the turnout and summary values from numeric to...

Oops, sorry, I misunderstood. I said I needed it on a See-Spot-Run level. ;-) Anyway, I'm making progress. For your sake and the benefit of anyone reading this thread, I'll take it step-by-step. After your last post I engaged in some trial-and-error, which, combined with exploring the...

OK, I'm back on this. Sorry for the delay ... had some other things come up in the office. I tried this: [{%minUSEN}:] ( select min("Manpower_Record_Time") from "UDT4"."dbo"."v_Manpower" where "Code" = 'USEN' and "Unit_ID" = "UDT4"."dbo"."v_Manpower"."Unit_ID" and "Incident_FK" =...

Just a quick reply ... haven't had time to do this yet, and I'm out of the office tomorrow. I'll take a whack at it Thursday. Thanks again for your help and your patience.

OK, I'll try that. What's the "A" for anyway?

Yep, I pasted it directly from your post.

LB, thank you very much for your detailed response. I'm encouraged by the confidence you seem to have that we can get this working. That is, assuming it runs quickly enough. For now, however, I'm getting an error. I pasted the first expression into a new expression field named "Enroute" in...

Thanks, LB. I've seen your many helpful posts in other threads, and I was hoping you'd respond here. No I'm not sure I need to use an alias table. I've used it only because I know that's one way to get the data I need into the report. If you can describe how to do it with a conditional...

I have a need similar to this: http://www.tek-tips.com/viewthread.cfm?qid=1578600 It's similar in that I want a report-level average for various ambulance response intervals (turnout time, drive time, etc.), as well as the following report-level summaries: minimum, maximum, median, 90th...