Alright, I have ten different queries. Here is the SQL for one of them.
SELECT [DCU LOG].[Doc#], [DCU LOG].JCN, [DCU LOG].[PART NO], [DCU LOG].SERNO, [DCU LOG].[JD T/I], [DCU LOG].MCN, [DCU LOG].PC, [DCU LOG].STATUS, [DCU LOG].REMARKS, *
FROM [DCU LOG]
WHERE ((([DCU LOG].[JD T/I]) Between...