After Append Table, new records are not calculated

[ajengel84]

I am very new to Access. I have a table with approximately 40,000 records currently. I have an append query created that is updating the primary table each day to add the new records (approximately 200 per day). I have set the format of the table for all times to reflect Long Time. However, when I run the form that analyzes the data and looks at time it the driver to complete the stop, it is not pulling the new data that I added via the append query.



Let me know what I need to post in order to be understood. Again, very new to this. Any help is greatly appreciated.

[JoeM]

What is the Data Source of your Form?
Is it a table or a query?
If it is a table, make sure it is referencing the correct one.
If it is a query, please post the SQL code of that query.
Also, if you are running the Append Query and Form in the same process, you may need to Refresh/Requery to see your new results.