P

#### PsyberFox

I have a query calculating months between certain dates... I have six date

fields, 3 start dates and 3 end dates. Not all 6 are complete for all

records, and some records have e.g. not the last start / end dates. When I do

a datediff calculating the months of the different date ranges (add result of

each datediff together to get the total number of months of all ranges), it

does not calculate for records where any of the start / end date is blank...

how do I get around this?

Thank you!