Is there a way to use a reserved word in a field name?

[Ai_Jun_Zhang]

Hi!

In the field names of my table, I have one field called Group. However, it is a reserved word in MS Accesss. My question is: Is there any way that we can use a reserved name in a field name?

Please advise,

Regards,

Aijun.

 

[Ai_Jun_Zhang]

Is there a way to use the reserve name in the select statement?

Hi!

I can use the fldGroup in the table. But when I do the select statement, I would like to fldGroup is presented as Group to users. So, in my select statement, I have

Select fldGroup as Group from myTable

This gives me error saying that I have include reserved word in my select statement.

Is there any way that I can use the reserved word as a presented field name in my select statement?

Please advise.

Regards,

Aijun.

 

[john471]

Not certain if this will work for you, as I don't get that error message in AC97 when I try it Uncle Gizmo's way, but here is another way.

Don't use the "AS" in the SQL, (or alias:FieldName in the QBE grid), instead just use fldGroup, then in the QBE grid, right click on the column and choose Properties, then give the column a Caption (Group).

HTH

Regards

John.