Error when selecting a column name called LINENO

[jmueller]

There must be an easy answer to this one! Can somebody please tell me how I can get around this problem:

I'm simply trying to perform the following select stmt:

Select PONO,LINENO,MATNO from bbpoline

And I get the following error:

Incorrect syntax near the keyword 'LINENO'.

LINENO is a function (turns blue in the stmt) so i'm sure this is the problem but how do I get around it?

Thanks for any help you can give me.

Jack.

 

[SQLBill]

Use square brackets [ ] around lineno.

Select PONO,[LINENO],MATNO from bbpoline

-SQLBill

 

[jdegeorge]

Jmueller:

I don't see that it's a reserved word by Access, but what I usually do in that case is surround the fields with brackets [ ], and if that doesn't work I re-name the item.

Hope this helps.

Jim

"Get it right the first time, that's the main thing..."

 

[jmueller]

Thanks SqlBill. I really appreciate your quick response.

 

[jmueller]

Thank You also Jim. Brackets work fine.

 

[jdegeorge]

You're welcome. Have a great weekend!

Jim

"Get it right the first time, that's the main thing..."

 

[SQLBill]

Jim,

You said "I don't see that it's a reserved word by Access". But it IS a reserved word in Microsoft SQL Server which is what this forum is for.

-SQLBill

 

[jdegeorge]

Bill

Didn't realize that, but the bracket solution works for both Access and SQL.

I was clicking between several Access forums and this one, not realizing that I stayed in the SQL forum. I'll pay better attention next time!

Jim

"Get it right the first time, that's the main thing..."