Recent content by majordoc

Hello all Thanks for any help. See attached file. First I know it's a crap database structure and I am endeavouring to change this. I am not a professional, just trying to set up a small database to help me look after patients. On the "Select Patient" combo box (number 147) I have two...

Thanks you all for your help - really appreciated. I know this is a crap database structure. This will only ever be a very small project really. In terms of separating tables, what is the fastest/easiest way to do this? E

Sorry - forgot file.

Hi all I'm sure this is easy but can't figure out a good way to do this (newb - sorry). I have a database of patients I see - I'm sure it's not structured very well but I have been using it for a while now. I have a number of fields for clinic dates (which again I know is not the best way to do...

Hi MajP. Yes that would be ideal. The date of the latest result is the most important. Your table at #17 looks amazing - there was no file attached for me to try an look at/copy if you can kindly post? E

Hi MajP Yes that would be absolutely ideal. The date of the most recent result is the most important. Your table at #17 is brilliant - can you send attach the file if possible, I couldn't see it? E

First thank you all so much for your time and help here - am in awe at the willingness for people to help each other. I can see immediately why an EVA model is so powerful and probably, in the hands of yourselves, the right way to go. I agree with plog that a bit of underthinking might be more...

Also - I though it might be useful to show the table of investigations that i had drafted so far for the actual database - as you can see there quite a few with more to come. Could I conceivably use Ix_Type for all of these?

Thank you both MajP and plog for your advice - I'm absorbing as you go along. I can assure you I'm not set on any particular method here. Plog what you say makes eminent sense. In this new test database I have replaced NT-ProBNP field with Ix_Type (for investigation type) and put in a second...

That's great! In total there are about 110 different numerical test result fields in the actual patient database. Even if less efficient, I think using a DMax and DMin function may be easier but I can't get that to work either - see above. And I need the dates associated with the max and min...

Thank you - have attached

I have created a calculated control in a form with following: =DMax("Nt-ProBNP","PH Investigations") but all I get is a flickering error message #Error on the form in Form View. Any ideas?

Hi. Thank you very much for this. I have hundreds of such queries for various tests etc. I have tried using DMax - apparently can be used in a calculated control but not a calculated field?

Hi there Many thanks. Yes I did this and works fine. Any ideas how to fix the original database though?

Hello all and thanks again for any help. I'm using this dummy simple table to try and figure out how to performs some queries that I need to use for a large patient database. I need a query to get the max, min and most recent blood result for each patient. There is apparent table where HandC is...