row number?

[accessliz]

Hi

not sure how to explain this, im not the best of access users and i dont understand SQL.

i have a table of patients having operations.
I have columns consisting of:
OP DATE, PT NUMBER, THEATRE ROOM, SentforTime,TimeinAR,TimeinTH,TimeinRecovery,TimeoutRecovery

i need to work out the time difference between a patient going into recovery and the next patient being sent for
I would need to probably sort the data by opdate and theatre as i would be reporting by each theatre, each month.


i thought i could use a made up row number to query both rows of information required to calculate this?

any ideas?
appreciate your help if its possible
thanks
Liz x

 

[Alansidman]

This thread may be what you need.

http://www.access-programmers.co.uk/forums/showthread.php?t=138016

 

[plog]

You most likely need to use DMIN (http://www.techonthenet.com/access/functions/domain/dmin.php) to get the SentForTime just after the TimeOutRecovery of the record you are working with.

What type of field is SentForTime and TimeOutRecovery? Does THEATRE ROOM come into play--Or is it the SentForTime of any patient not just the last one in that THEATRE ROOM?