Can't Open Report due to Syntax Error

[DJ1977]

Hi,

Not sure if anyone can help me - I am a new user of an old access database which I am having trouble with.

I have updated a report in design view (letter template) and in the predetermined telephone field in between the [brackets] I tried to update it and entered my email address - which I should not have done as this has mucked up my report and I now cannot open it.

The following error now comes up when I try to open the report "Syntax error in query expression '(([info@email.com. au].com])).

Now I can't work out how to fix this as I cant seem to open the report to remove this email address - have tried various options including design view etc.

Any tips or help would be greatly appreciated.

Thanks in advance.

[Seth Schrock]

What version of Access are you using? You can open the report in design view without first opening it in preview or report view. Then the syntax would be ='exactly how you want it to appear'.

[zmbd]

I know this is too late for you... however, for the others that follow, your post will serve to be "case-in-point"

- ALL WAYS have a backup of your production database!
The frequency of the backup depends upon the amount of data and the sensitivity to loss.
Whenever possible, have a second backup on a different server, pc, or offline storage.
- All ways BACKUP your database prior to changes.(front-end,
back-end, or integrated, doesn't matter)
- Make a copy of this backup... this will serve as your development database (front-end, back-end, or integrated, doesn't matter)
- NEVER make changes to the current "Production " database!

--
>OK<

(z1>>>) The following error now comes up when I try to open the report "Syntax error in query expression '(([info@email.com. au].com])).

(z2>>>) ow I can't work out how to fix this as I cant seem to open the report to remove this email address - have tried various options including design view etc.

z1) This tells me that when you went into the report and altered the field you altered a control that the the underlying report query was depending upon to pull information for the report.

z2) Can you open the report in design view? It is unclear if you can, and there's noway to fix this unless you can open the report in design view.

[DJ1977]

Its 2007 - Thank you I managed to open it in the Nav pane somehow and was able to change it!

Now fully backed up - appreciate your help.

[zmbd]

YEA!!!!
I love the easy fixes (^_^)

Sometimes, a simple shutdown and reboot of the PC is all it takes.

Glad you have the backup made and thank you for allowing me to point the need for this essential step in database design.