criteria in a query

[damsel]

Hello from a newbie

I would like to do a customer monthly report from last year fiscal year. It starts from July 2001-July 2002.

In Dec 25, 2002, I want to report list of customers that are still with us in a particular month.

I have Customer table with: CustID, AddDate, and DropDate Fields.

June 2002 Customers = new customers that are added before 6/30/02 + old customers that are still with us until 6/30/02 - old customers that are gone/dropped before 6/1/02.

How would I create a query out of this?
Thank u for the help.

 

[ColinEssex]

In the query criteria put this

AddDate . . . . . . . . . . . . . . . . . . . . . . .. DropDate

<[Enter month end date].....................IsNull
<[Enter month end date].....................> [Month start date]



I think !!

BTW your fiscal year contains 2 july's it should be July to June

Hope this helps
Col

 

[damsel]

Works wonderfully. Thanks a lot Colin