Search results

Thank you Pat. This is not an error. What causes this is that the user may go back to the same account later in the day.

Here is the data that pertains to my problem. The highlighted segment represents two different times the user entered an account in the same day. Right now I just use a datediff between "Punch in" and "Punch out" The problem is it calculates the difference from both entries do I get erroneous...

Good day all- I have an access database that I have been using for a very long time. To use a tree analogy, it has grown many branches and a lot of them need to be pruned. Is there a best practice or tips you have to help the process of removing all the dead wood from the DB. Any help or...

Hello all. I have a database that collects workers punch times. Table fields are as follows (TransactionKey,UserId,Customer,PunchTime,PunchType) I calculate the time spent at the customer by using a datediff between a "Punch in" and a "Punch out" My issue is some users have started visiting...

Good day all- I have a database that has been around for about 20 years in some form or other. I would like to clean it up, remove objects that are not used anymore. Anyone have any advice to do this in a productive, non destructive manner? Thank you

Hello all- I am running a split database with sqlserver as the back end. Most of the work is viewing images of work completed in the field and I am stuck reviewing them. Right now I query the server to pull all required data and place it in a temporary table on the front end. This includes...