query by future paydays

[home70]

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 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 from the transactions that are coming out of this payday.
Thanks for your help.

 

[grnzbra]

You might want to play with

IIf(Day(Now() > 1 and Now() < 15, Month(Now()) & "/15/" & Year(Now()), Month(Now()) + 1 & "/1/" & Year(Now()))

You'll have to add another IIf() in there to handle a situation where Now is between 12/16 and 12/31.