Can anyone figure out where the parenthesis and comma's might be wrong below?

Nights: IIf(DateDiff("d", IIf(CheckInDate < [Start Date],
[Start Date], IIf(Nz(CheckOutDate, Date()) > [End Date],
[End Date], Nz(CheckOutDate, Date()))) = 0, 1),
DateDiff("d", IIf(CheckInDate < [Start Date], [Start Date],
IIf(Nz(CheckOutDate, Date()) > [End Date], [End Date],
Nz(CheckOutDate, Date()))

-- 
Marsh
MVP [MS Access]


-- 
Rose

Rose

When I end up with one of these, I start counting, adding 1 for each left 
paren and subtracting for each right paren ... ditto for other brackets.

I do have a question about this phrase:
     IIf(Nz(CheckOutDate, Date()) > [End Date],
     [End Date], Nz(CheckOutDate, Date()))) = 0, 1)
which seems to have an extra "=0" in the "false" side of the IIF().

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Rose" <Rose@discussions.microsoft.com> wrote in message 
news:874DDE30-B751-4FEE-A561-63AB4030743F@microsoft.com...
> Can anyone figure out where the parenthesis and comma's might be wrong 
> below?
>
> Nights: IIf(DateDiff("d", IIf(CheckInDate < [Start Date],
> [Start Date], IIf(Nz(CheckOutDate, Date()) > [End Date],
> [End Date], Nz(CheckOutDate, Date()))) = 0, 1),
> DateDiff("d", IIf(CheckInDate < [Start Date], [Start Date],
> IIf(Nz(CheckOutDate, Date()) > [End Date], [End Date],
> Nz(CheckOutDate, Date()))
>
> -- 
> Marsh
> MVP [MS Access]
>
>
> -- 
> Rose 

Thanks for your help and clever way to check the , and )
-- 
Rose


"Jeff Boyce" wrote:

> Rose
> 
> When I end up with one of these, I start counting, adding 1 for each left 
> paren and subtracting for each right paren ... ditto for other brackets.
> 
> I do have a question about this phrase:
>      IIf(Nz(CheckOutDate, Date()) > [End Date],
>      [End Date], Nz(CheckOutDate, Date()))) = 0, 1)
> which seems to have an extra "=0" in the "false" side of the IIF().
> 
> Regards
> 
> Jeff Boyce
> Microsoft Office/Access MVP
> 
> "Rose" <Rose@discussions.microsoft.com> wrote in message 
> news:874DDE30-B751-4FEE-A561-63AB4030743F@microsoft.com...
> > Can anyone figure out where the parenthesis and comma's might be wrong 
> > below?
> >
> > Nights: IIf(DateDiff("d", IIf(CheckInDate < [Start Date],
> > [Start Date], IIf(Nz(CheckOutDate, Date()) > [End Date],
> > [End Date], Nz(CheckOutDate, Date()))) = 0, 1),
> > DateDiff("d", IIf(CheckInDate < [Start Date], [Start Date],
> > IIf(Nz(CheckOutDate, Date()) > [End Date], [End Date],
> > Nz(CheckOutDate, Date()))
> >
> > -- 
> > Marsh
> > MVP [MS Access]
> >
> >
> > -- 
> > Rose 
> 
> 
>