Access Union Query - Inconsistent Date formatting

Hi, I'm working with a union query that brings together 8 or so queries with all identical columns, separated for ease of user entry due to the volume of information in each.

I've formatted the date field in each query to Short Date. The individual queries look perfect. When they're viewed in the Union Query, some (seemingly random) rows also show the time alongside the date.

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

No, I'm totally confused about that. These tables are pulled into Access via Sharepoint. They're linked tables. The users enter their data in sharepoint and I pull it in to Access. I double checked the date/time option in sharepoint and they're all set to date only. I can't change the table formatting in Access (because Sharepoint is the boss) but I did change it in the query. In all the queries, it looks great. Except the union query. That's where I'm having this issue.

Featured Post

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…

Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…