I have an access table, and there is a field called user_time. Once a user record has been inserted, it puts a timestamp on this field, to record the date/time the record was saved to the database.
Now I need to write a query to check if it has been 72 hours since the insertion of the user into the database. This will exclude weekends.
If a record was inserted on a Friday, on Monday it will not be 72 hours, as weekends are not taken into account only weekdays. So Monday will only be 24 hours since the user was added.
Please can you help me with this.
Now I need to write a query to check if it has been 72 hours since the insertion of the user into the database. This will exclude weekends.
If a record was inserted on a Friday, on Monday it will not be 72 hours, as weekends are not taken into account only weekdays. So Monday will only be 24 hours since the user was added.
Please can you help me with this.