this query returns no records:
SELECT Universe_v3.Date, Universe_v3.Ticker
FROM Universe_v3
WHERE (((Universe_v3.Date) Between #5/30/2012# And Date()));
Is it possible that the field name of Date is throwing a monkey wrench into the query? If I clear the criteria all records are returned.