Randy, Yes... your correct. I apologize, I guess I'm not as smart as I
thought I was. I figured if I could create a simple scenario for you, take
your logic and make my query work and I can't. To answer your question, yes,
it's for multiple OR's but I fugured it may be easier if I set it up to look
at one OR at a time, thus the prompt for the OR field. I really wanted to
make this report group by OR and show me the elapsed time "between
procedures". Obviously, The way I have it set up now is about half baked. I
really appreciate your help, thanks.
--
If you can read this, thank a Teacher...
If your reading it in english, thank a Veteran!


"Randy Harris" wrote:


"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?