Megagnome
Last Activity: May 18 '13, 12:28 AM
Joined: May 16 '13
Location:
-
Thank you, thank you kind Rabbit! MUCH better. By sorting DESC and restricting the ListRows to 1 our receptionists now have no choice other than the correct number. Most grateful! -
So,
then place this as Record Source for field PrevAccNo? Certainly much simpler, but please confirm!Code:SELECT max(AccessionID) FROM TBL_Accession WHERE AccessionID <> Me.AccessionID AND FirstAccNo = Me.FirstAccNo
Leave a comment:
-
Rabbit, the problem that I see with what I think you suggest is that that would give me the highest (max) AccessionID. I don't want that value. It's the PREVIOUS value we want, that is, 22358, NOT 22359 which would be the max, and yes, I agree that if I wanted the max I'd have no need for the code.Leave a comment:
-
Thanks VERY much, 'Rabbit'! What would my 'max aggregate query look like? Could you give me a clue as to the SQL? That's a term that is new to me!Leave a comment:
-
Run-time Error 3061 - Recordset
Got myself in real need of help here, and wonder whether anyone would be able to assist?
Problem:-
In a wildlife hospital we want to automatically select the ‘Previous Accession Number’ under which an animal known by its ‘First Accession Number’ (or ‘PatientID ’) was last treated by CWH before the current consultation instance.
Each instance of an animal entering the wildlife...
No activity results to display
Leave a comment: