"Telobamipada" wrote in message
...
Randy, Let's try it like this (I haven't had time to work on this for
awhile)

I'm using MS Access 2002
My Table is named "Master Data"
I have a query looking at the fields "ID", "Date", "OR", "Procedure",
"SUrgeon", "In OR" and "Out OR"...
There can be multiple records in this table for each day by "OR" (which is
Operating Room).
I am trying to set up a report that can show me the elapsed time from the
"Out OR" time of each record to the "In OR" time of the next record so I
can
tell how much time passed between procedures for each OR. I do not want a
calculation to be done if the "OR" field is different. In other words, I
do
not want to compare a time from Operating Room 1 with a time from
Operating
Room 2. I had my query designed to ask for which "OR" is to be used but it
still does the calculation based on the next record by the "ID" field.


This is the first time you've mentioned OR.

What do you mean by "I had my query designed to ask for which "OR" is to be
used but it still does the calculation based on the next record by the "ID"
field."

It sounds like you are prompting for the OR, then generating a report for
that OR. Is that correct?

Is this report supposed to be for one OR or multiple ORs?