Date Data Missmatch

[sir_dan_mitchell]

Hey can some1 help me with this problem. Its pretty simple probably, but we'll see anyway...

I have 3 queries that I need to add up.
One is adding non_members fees and one adding non members fees & if they became and member after the particular social date.
Finally one with members fees.

Now they all work fine normally, but if I put a date that is then greater than a social date, although the individual queries work fine, the overall Sum query of the 3 says 'data missmatch'.

All have Nz(Sum([Field]),0) etc and work fine as I say on their own. They all come up with the right values individually AND if the date is BELOW the social date. So WHY when it goes bigger than this date does it suddenly become a missmatch?

Examples of the fields are as above with [member] Condition Yes or No depending on which query it is.

the overall adding Query TOTAL just Sums the queries. How does this course a missmatch?

Any help would be grately appreciated, thanks

Dan

 

[wizcow]

Dan

This is a guess.
If any of your dates are formated like this Now() or Date() ...
They have to all be one or the other.
Mixing the formats can cause errors.

HTH
Tom

 

[sir_dan_mitchell]

Im afraid not,

I am calculating money totals, thats why ive had to use Nz( etc as if there are nulls I want it to display zero.

All the queries displayed display a number (Sum), but I cant add them all up WHEN the [joined date] >= [venue Date]

Anymore ideas?

Dan