CODEWITHSUNDEEP
sqlsql-serverms-accessms-access-2007
Gedalya
Gedalya

Reputation: 909

Unable To Run Access Report With Column Name Which Has Special Character

I'm trying to run a report in Access that references a poorly named column: Vendor#. For those of you not familiar with Access: '#' is a reserved keyword with special meaning. I've been trying to run the report and every time I do a popup appears asking for a value for the column: in other words it keeps seeing it as a variable name. I've tried a number of variations on the name including: [Vendor#], 'Vendor#', ['Vendor#']. I tried an Alias but then I encountered the same issue in the where clause referencing the Alias. No I can't change the schema to rename the column to something more appropriate. Any help is appreciated.

Here is the query:

SELECT * FROM dbo_Vendors
WHERE ((dbo_Vendors.[Vendor#]) = [Forms]![frm_Report_Vendor]![VendorNumber])

Upvotes: 1

Views: 212

Answers (1)

Fionnuala
Fionnuala

Reputation: 91366

I have just tested with a linked sql server table having a column called Vendor#. I can create a report and it runs correctly.

Can you save the query and test that the query runs? I suspect that you may have a misspelled form reference, because I have tested the whole scenario and it works for me. I do not think the report has anything to do with it.

Upvotes: 1

Related Questions