Crazy over calculation

  • Thread starter Thread starter jsd
  • Start date Start date
J

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)


..
 
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.
 
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)
Click to expand...

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!
 
Back
Top