AFRs To Close Query

[billgyrotech1]

Hello,

I created a query (AFRs To Close) to show 'Open' AFRs (records) that have Finished Dates that I would like to change the Status field to 'Closed' at the end of the business day.

Can this be done automatically by computer time or maybe a button to click?



Thank you

[orange]

Cross posted at https://access-programmers.co.uk/for...d.php?t=305365 and
https://access-programmers.co.uk/for...d.php?t=305388 with responses and marked Solved???

and seems to be a continuation of https://www.accessforums.net/showthread.php?t=77120

[billgyrotech1]

I have no idea how this relates but to each his own.
Bye

[billgyrotech1]

You must not have read the initial post correctly. All I am trying to do with this thread is to change the Status field.

[orange]

Try

UPDATE AFRs SET AFRs.Status = "Closed"
WHERE (((AFRs.Status)="Open") AND ((IsDate([AFRs].[FinishedDate]))<>False));

You could invoke the query from a button or other condition based on requirement.

[billgyrotech1]

Thank you that works by manually running the code. It closes AFRs that have Finished Dates.

Can this possibly show the AFR Numbers in question then have a message saying: "Are you sure you want to close these AFRs?"