How do I find all checks written on a specific day via an ODBC connection?

I'm on Sage50, 2019.  I've connected to the ODBC driver and have found the following query gets me part way there.

SELECT a.Reference, a.AmountPaid,a.Description,
a.JrnlKey_Journal, a.TransactionDate, a.MainAmount, a.Reference, a.TrxName,
a.* FROM JrnlHdr a
WHERE completeddate = '2022-06-30'
AND AmountPaid <0

I cannot get accurate check numbers for the checks.