Query Question

  • Thread starter Thread starter nvacek
  • Start date Start date
N

nvacek

I have a query set so I pull distinct dates say from 1/1/08 thru 12/31/08 to
take out duplicate accounts, I need to run this on a monthly level. I need
to run this report in 2/08 and I do not want the accounts whom I have counted
in 1/08 to show up in my 2/08 report and so on. I only want them to be
counted 1 time in the year.

What expression or operator words can I use. I have tried for example
between 1/1/08 and 12/31/08 and between 2/1/08 and 2/29/08. This string will
pull in my 2/08 accounts but it is also pulling in 1/08 accounts if I had
contact with them in 2/08.
 
I use a query that pulls dates from a form. The Criteria box in the query
contains
"Between [Forms]![frmName]![txtFieldStartDt] And
[Forms]![frmName]![txtFieldEndDt]". Then I fill in the date period desired
into fields txtFieldStartDt and txtFieldEndDt and click on a command button,
allowing VBA to perform the report open, which gets its data from the query.

EarlCPhillips
Volunteer Ex-Mainframer Learning Access
Harvesters Community Food Network
 
Back
Top