Combine Record Data and Time Calculations

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

Joe,

You could write a crosstab query with (Call#, CallDate and Unit#) as the row
headings,
a computed field (see statement below) for the column Header, and the
StatusTime as the Value (you would probably have to set the Total Row of the
query grid to FIRST for this column).

Your computed field would look something like:

Expr1: IIF(StatusType = 41, "AHTime", IIF(StatusType= 33, "ESTime",
"AVTime"))

HTH
Dale
 
Any ideas? Here's the situation:

Each record contains a Call#, CallDate, Unit#, StatusType,
StatusTime.

Each record has only one type StatusType and the
corresponding StatusTime (so the other record data remains
the same). So, it takes upto 3 records in my Access data
to get the real picture of what needs to be one longer
record.

What I want to do is if the Call# is the same, and the
Unit# is the same for records in the file, put the
StatusTime in one of 3 fields (AHTime, ESTime, AVTime),
depending on what value is in the StatusType field. If
StatusType = 41, then StatusTime = AHTIME. If StatusType
= 33, then StatusTime = ESTime. If StatusType = 20,then
StatusTime=AVTime.

I can get the StatusTime data in the correct field using a
query, but I still endup with 3 separate records, when
what I need is one longer record with all the data and to
get rid of the other records that contain the
information. If I can get this done, I think I could then
calculate the time difference between each type of time.
 
Back
Top