Thank you gents for your input!
I took Trav’s advice regarding the query, and it wasn’t drawing out the info.
I changed the date property from .date (which sent m.d.y.h.m.a to my table) to .text (which sends just m.d.y), and then the query pulled the info across.
Thanks for the second set of eyes on this!