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.
Any suggestions as to why or how to fix? Thanks.