query Syntax Error Access VBA

Question

I am trying to set the

Me.RecordSource = "SELECT Sequence No,Catalog Number,PO Number,Assignee,Customer Name, Marketing Sales Mgr, Notes, Rating Information From Catalog Number Log 2 WHERE Catalog Number Like '34*' ORDER BY Sequence No"

but it is giving me a Syntax error. Any ideas why. Any help would be appreciated.A screen shoot of the table is shown below.

Table Catalog NUmber Log 2

Use [Sequence No] where column name contains spaces. Catalog Number etc. — gembird
– gembird, Commented Dec 29, 2014 at 18:36

user2941651user2941651 · Accepted Answer · 2014-12-29 18:36:58Z

2

Please try this:

Me.RecordSource = "SELECT [Sequence No],[Catalog Number],[PO Number],[Assignee],[Customer Name], [Marketing Sales Mgr], [Notes], [Rating Information] From [Catalog Number Log 2] WHERE [Catalog Number] Like '34*' ORDER BY [Sequence No]"

You have white spaces in your table and column names hence they have to be put in brackets [ ] .

answered Dec 29, 2014 at 18:36

user2941651

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

query Syntax Error Access VBA

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related