Query for records before paydays

Giganews Newsgroups
Subject: Query for records before paydays
Posted by:  rinmanb70 (emailchris…@gmail.com)
Date: 18 Aug 2006

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.

Replies