excel database criteria problems 1

[lespaul]

Hello all,

I am trying to do some database functions and I'm having difficult with using dates as criteria.

Here is some sample data and the criteria that I'm trying to do:

Sample Data:
Officer: Denise Heppler
ChargeType: DV
Sex: M
OpenDate: 1
Odate: 5/9/2002
Complete: blank
Cdate: blank

Officer: Peter Boyles
ChargeType: DV
Sex: M
OpenDate: 1
Odate: 5/2/2002
Complete: blank
Cdate: blank

Officer: Terese Hauge
ChargeType: District
Sex: M
OpenDate: 1
ODate: 5/29/2002
Complete: 1
Cdate: 5/31/2002

Named criteria range:
Name:cr_SCASES
Criteria: Officer = David Martinez AND OpenDate = 1 AND Odate <= sdate

sdate is a named range that is populated with 5/1/2002. I need to know the number of open cases at the beginning of the month.

I then need the number of cases closed in the month

Name: cr_CLOSE
Criteria:
Officer = David Martinez AND Completed = 1 AND cdate<= edate


How can I use dates as a database function criteria?

Thanks,
leslie

 

[DaleWatson123321]

Hi Leslie,

I believe I'll be able to help out.

If you would like to email me a copy of your file, I think it will save us BOTH time in isolating the problem with the criteria.

I'm pleased to see that you're taking advantage of Excel's POWERFUL &quot;database functionality&quot;.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[lespaul]

Thanks for your help Dale,

The Excel database functions take some getting used to, but they are really cool! You can do so much with them.

thanks for helping!

Les