SQL Problem: reserved word

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
insert error 10
Set Querydef SQL to Null (Open an empty query editor) 20
DoCmd.RunSQL - Need help! 1
Displaying Currency 3
Decimal places in a temporary table 3
What are the steps to fix damaged MDF files in SQL Server? 0
Union Query Format 6

Back
Top