How to use autoexec combined with date() or Now()

[tosv1516]

Hi.
I have read a lot , but not found a solution to achieve the following:
In a db I wish to get to a post of the current day as now() or date() , if it exist.
If not exist a record holding today's date, I wish to create it, and then work with it ( set focus ).
The purpose is to have an autoexec that either show the current already started record for today,


or create a new one to work with, and avoid getting double posts in the db.

Is there a simple yet effective solution to this ??

Best regards....
Torgeir

[hertfordkc]

to determine if today was a new day. If the reference date was less than today, I entered today's date into the reference table and carried out the special action. The concept works whether you are working on daily, monthly or yearly actions. Hourly and minute by minute actions could work as well.
However, if you already have a table that contains a date which could be reference as the last update, then you wouldn't need another table.
Since you are concerned about day intervals, you need to do your comparison with value in which the smallest unit is days.
Google "access date functions".
Date() might be sufficient but I believe that for some reason I constructed a date value using Date(), DatePart, and DateSerial.