Recent content by JulieAsking

OldSoftBoss I didnt see your reply before my last post. Okay. I see now that I cannot rectify this situation. Thank you both for your help. Julie

Thanks for answering, llkhoutx. As my Form stands, the PatientId numbers and navigation button numbers do match all the way through to where the navigation button shows 487 but the PatientID number is 488 (the record for PatientID 487 no longer exists - I have checked this in TAbles). From...

I have Access97 and have a form and subform set up to record surgical operations for patients. I have an autonumber primary key for PatientID. I noticed when entering data on the Form recently that the record number on the navigation button of the form was one number less than that showing for...

Sorry guys, I've just solved the problem. Julie

I'm using Access97 and have a subform within a form. The main form has navigation buttons in the Form footer which I can clearly see once I switch to Design View. However, I am unable to see the form footer for the subform as in Design view it just shows as a white rectangle with the name of...

ANGSHU - Many thanks. What a simply wonderful solution you provided me with. My db is set up just the way you suggested in your second post. I ran the wizard to find the duplicates in the Patient ID field of the Operations Table and once this was up I simply added the Patient Details table and...

Pat, Thank you for your reply. When trying: Select PtID, Count(*) From TPtDetails Where Count(*) > 1 Group By PtID; I get a message saying "Can't have aggregate function in WHERE clause [Count(*) > 1]. I'm a newbie and am not sure what this message means. Julie

Sorry, I meant to mention re my question above, that when I run a query to show me the patients who have had multiple operations, Access gives me names and the total number of operations they had and, if I had the Procedure field to the query, the FIRSTLISTED type of operation. What I want is...

I have an Access97 database listing surgical operations for patients. Most patients will have only one operation but a few will have multiple operations. I want to know how to set up a query to ferret out those patients who have had more than one operation. There are two tables, one for patient...

Thanks so much for replying Seth. I apologise but I made a wrong assumption about a particular query outcome. On re-doing the query all is well. Thanks again - Julie

Hi. I'm a novice but I managed to construct a MS Access97 db which is working well as far as inputting data. However, I have a problem with querying. The db is a record of patients and their surgical operations. The construct is a subform (continuous) within a form. Querying works fine if the...

No problems, Shay. Thanks for your reply and I hope you dry out soon! Julie

In case it helps anyone who is not familiar with SQL I got this done using the grid. I dragged firstly the name field to the grid, then the Patient Id field. I clicked on the Total button in the toolbar which inserted 'Group By' in the Total cells. I left this stand under the Name field but in...

Thank you for replying Shay. This is what I did firstly: I changed your code to read exactly as my table/field names read. I then copied and pasted the code into the Criteria area of the grid in the column including the Field of PtID and the Table of TPtDetails. I got a message:The synax of...

I have a database of surgical operations. I wish to discover which patients over 2002 had the most surgical procedures done on them - say the top 10 patients. I think this query will have to be worked on the autonumber Patient ID number as it is the only column that shows repeats. eg. Patient...