Error Message!

[christy]

Is there some kind person out there that could define this error meesage i get when i try to analyse a report with excel>

'There is an invalid use of the .(dot)or in invalid parentheses'.

'You may have entered an invalid indentifier or typed parentheses following the null constant'.

Any help woul be great
Thanx..........Christy

 

[NightPort]

if it is giving you the error because of the first part then you have parentheses that shouldn't be there or you have a period that shouldn't be there. For the secong part you may have entered an identifier it does not recognize, that could be any mathmatical situation, get the spelling wrong, or you just used the wrong spelling of that specific function, and I'm not exactly sure on the parentheses following the null constant. That may be that you have parentheses around a value that you defined as null. Hope this helps some.

 

[crawdad20]

I found this to resolve my same problem with this error.

In my form, I had a text box with this formula :

=([Forms]![frmReportOptions]![StartDate])

that was generating the error when I tried to export the report to Excel. I removed the "=" and the parentheses around the formula and it resolved my issue.