SQL Problem: reserved word

[Guest]

I am trying to programically insert this sql into a report's record source,
but I the "enter parameter value: currency" dialogue appears. The sql works
fine in a query. Currency is a reserved SQL word. Is this my problem? If
it is, how do i overcome it when the field name is "Currency". If it isnt,
what is the problem? Thanks in advance.

 

[Al Camp]

Access is telling you what the problem is...
Rename the Currency field to something like CurrencyAmt, and change it
wherever it's called out in any queries, form, and reports.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions