Another Data mis-match

[Egg 'n' Bacon]

I have tried allsorts, but I really am stuck as to why this (attached) does not work.

The chart used to work, and the underlying query works, until the last record is added. Strangely, this record is not selected in the first level query from which the chart query get's it's data from.

An ideas??

strippedDataMismatch.zip

[HansV]

I'm not sure why the DateSerial expression in the Row Source of the chart causes this error, but it works if you use

Closed: [DateClosed]-Day([DateClosed])+1

instead of

Closed: DateSerial(Year([DateClosed]),Month([DateClosed]),1)

[Egg 'n' Bacon]

Wow! I've found a chink in the encyclopedic knowledge and experience of the mighty Hans

But thank you for a solution

[Pat]

He still wins Hans down though !!!!

[HansV]

Hans is seldom down!

[JohnH]

The problem is not actually with using DateSerial. If you remove the criterion >#12/31/2009# the DateSerial works correctly.
The problem is applying the criterion to the calculated field.
You can keep DateSerial by adding the DateClosed field and applying the criterion to that.

Applying criteria to calculated fields usually works, but if the calculation gets complicated it sometimes produces hand to understand errors.

Strangely, this record is not selected in the first level query from which the chart query get's it's data from.

Record 923 is the last record that is both counted and has a date closed, so it is the last record returned by the query.
Record 926 does not have a date closed.

[Egg 'n' Bacon]

The problem is not actually with using DateSerial. If you remove the criterion >#12/31/2009# the DateSerial works correctly.
The problem is applying the criterion to the calculated field.
You can keep DateSerial by adding the DateClosed field and applying the criterion to that.

Applying criteria to calculated fields usually works, but if the calculation gets complicated it sometimes produces hand to understand errors.

Strangely, this record is not selected in the first level query from which the chart query get's it's data from.

Record 923 is the last record that is both counted and has a date closed, so it is the last record returned by the query.
Record 926 does not have a date closed.

I could have sworn I tried that.

Any idea why it threw up the error?

[HansV]

I guess that the query optimizer attempts to combine the queries; this causes a problem because DateSerial(Null,Null,1) can't be evaluated.