Query for records before paydays

[rinmanb70]

I have a table of checking transactions. Some are past, some from
today, and some are dated with future dates (such as recurring
payments).
Is there a way to set up a query for my balance (credits minus debits)
that will exclude transactions that occur after upcoming paydays (1st
and 15th) dynamically? For instance, if I have a transaction scheduled
for the 2nd of next month (after payday on the 1st) I'd like to be able
to separate it dynamically/automatically from the transactions that are
coming out of this payday.
I have tried WHERE <=DateSerial(Year(Date()),Month(Date()),0)
but it only returns transactions up until this month.
Anyone know how to do this?
Thanks for your help.

[rinmanb70]

OK, I have found how to get it to return all transactions up to and
including the current month's:
WHERE datetransaction<=DateSerial(Year(Date()),Month(Dat e()),31);
where the 31 represents the date of the current month.

Also I see how to query for transactions after a certain date of the
current month, for instance this will return all transactions dated on
or after the 15th of the current month:
WHERE datetransaction>=DateSerial(Year(Date()),Month(Dat e()),15);

But now what I'm having trouble with is how to reference next month.