Crazy over calculation

[jsd]

I want to thank everyone who has responded to my
calculation/formula questions. Although, I still cannot
seem to understand why my calculation isn't working. I'm
in the process of designing an invoice report through
Access 98.

The following expression was not rejected, although I'm
prompted that there is an extra )??? I've tried to play
with the calculation but can't seem to figure out where.

Again any help is appreciated. Thanks!!!

DateSerial(Year(Date()), Month([Effective Date]), Day
([Effective Date]))& " to " & DateSerial(Year(Date()) + 1,
Month([Effective Date]), Day([Effective Date]) - 1)


..

 

[Van T. Dinh]

The parentheses are balanced out and the expression looks correct.

If the expression is wrong, Access would "reject" it, NOT prompting you
about an extra closing parenthesis.

 

[John Vinson]

I want to thank everyone who has responded to my
calculation/formula questions. Although, I still cannot
seem to understand why my calculation isn't working. I'm
in the process of designing an invoice report through
Access 98.

The following expression was not rejected, although I'm
prompted that there is an extra )??? I've tried to play
with the calculation but can't seem to figure out where.

Again any help is appreciated. Thanks!!!

DateSerial(Year(Date()), Month([Effective Date]), Day
([Effective Date]))& " to " & DateSerial(Year(Date()) + 1,
Month([Effective Date]), Day([Effective Date]) - 1)

hmmm... that looks familiar... <g>

If there's an unbalanced parenthesis it isn't in this expression.
Please open the Query where you're using this (it is in a calculated
field in a query, right?) and copy and paste the actual SQL text here.

The *only* thing that might be iffy is that you have the first &
concatenation operator right next to the closing parenthesis - try
putting a blank before it. Access should do that for you though!