Recent content by Jeff4505

Thanks, that worked great.

Hi I am working on an Access project for my ICT A2 level and was hoping someone could help me with update queries, we currently have a temp tutor who knows very little of this territory. Basically, I have to create a database for a Car sale and lease firm. I need an update query for a few...

Hi, I need to create a query that looks at the "last active" date on a member's table and to then change the "status" field to "inactive" if it is greater than 2 years ago. Thanks

Hi, I need to create a macro to run upon opening a database and to then find all "members" with a "last active" date that's greater than 2 years ago and to change their "status" to "inactive". Do you know how I would go about doing this? Would I create it to do each member one by one, or would...

Hi, Basically, I need my database to update a table/s when I close a form. It is a car rental and sale company and I need, when a form for either a lease or sale is completed, to change the field on the car table for the car to unavailable (ie it's on lease or has been sold), on the staff table...