Search results

UPDATE PrivateContacts SET PrivateContacts.[Total Lessons] = PrivateContacts.[Total Lessons]+1 WHERE (((PrivateContacts.ID) In (SELECT Last(PrivateRecords.[Name Of Student]) AS ContactID FROM PrivateRecords ORDER BY Last(PrivateRecords.ID)))); That did what I wanted.. Thanks for your help!

PrivateContacts!ID is an autonumber, [ID of last private records]![ID of last record] is not an autonumber does this help? Total lesson field in PrivateContacts: Query ID of last private records

This will work but would require me to enter the ID manually. I want it to be automated, so I made another query which finds the ID I want (see [ID of last private records]![ID of last record]). The value that this returns is what I want to put in your suggestion as [Enter ID Number]. how would...

that made the field [total lessons] increase by 1in all of the records, not just the one that I want. can you explain what does this supposed to do?

I want Total Lessons to be updated only when the ID's Match how do I solve this?

I would like to count how many times each private contact id appears in order in the private records (via relationship) .The result in the "count" column in this case should be (from top to bottom): 1,2,1,2,1,1 thanks in advance