Search results

keith, never mind my last post. i figured out the small syntax problem. works great. thanks!!!

keith, i'm getting a #error in the query. here's what i used: SELECT table1.ID, table1.ProcDate, table1.LabNumber, table1.[pt in room], DLookUp("pt out room","table1","ID=" & (DMax("ID","table1","ID<" & [ID]))) AS Previous, DateDiff('n',[Previous],[pt in room]) AS turn FROM table1; is the...

patient left room #1 in record #2209 at 8:23. in the same room, the next patient comes in at 8:32 (record #2210). so it's not only different records but different fields (patient in field minus patient out field). does that help?

yes, that sounds exactly like what i'm trying to do. here's a sample of my database: ID ProcDate LabNumber pt_inroom pt_outroom 2209 7/3/2006 1 7:26 8:23 2210 7/3/2006 1 8:32 9:44 2211 7/3/2006 1 9:40 10:47 2212 7/3/2006 1 11:15 11:54 2213 7/3/2006 1 13:27 14:53 so the...

thanks for the help. here's a sample of the database: ID ProcDate LabNumber pt_inroom pt_outroom 2209 7/3/2006 1 7:26 8:23 2210 7/3/2006 1 8:32 9:44 2211 7/3/2006 1 9:40 10:47 2212...

i'm relatively advanced Access user but this problem has got me stumped....i've been given a table that's basically a log of operating rooms with fields designating the date, the room number, "patient in room" time and "patient out of room" time. basically, i want to calculate the turnaround...

fix for "search key not found error" had the same error when trying to delete a specific record in a table. try undoing all primary keys temporarily to delete the record and then reset your primary keys.....worked for me.