Please, read my comment to the solution 1
I'd suggest query like this:
PARAMETERS [mnth] INT;
SELECT <FieldList>
FROM bene_records
WHERE b_date BETWEEN #DateSerial(Year(Date()), [mnth], 1)# AND #DateSerial(Year(Date()), [mnth]+1, 1-1)#
Above query should return data for given month (from first to last day).
Replace
<FieldList>
with set of columns you want to return. Do not use
*
together with
SELECT
statement, if you care about performance.
To call this, you need to set
OledbParameter[
^] for
OledbCommand[
^].
More:
DateSerial (MS Access query)[
^]
Data Types (MS Access)[
^]