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.

 

[Uncle Gizmo]

You should not use reserved words as names for the fields in your tables. However if what you are after, is a correct heading for your field where it appears elsewhere in your database, for example in a query or datasheet then what you could do is base a query on your table, and prefix the name in the query grid with the name you want to appear in your data sheet.

So if the query grid normally showed this:

Field Name >>>> fldGroup
Table Name >>> tblGroups

you would do this :

Field Name >>>> Group: fldGroup
Table Name >>> tblGroups

 

[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.

 

[Uncle Gizmo]

BTW, I should have mentioned, you can put a name that will appear at the top of columns in your tables and queries, and also when you add controls to a form, in the caption property of your table design.

 

[Pat Hartman]

DO NOT use captions in your tables. If you think you have trouble now, you haven't seen anything until you see what they do to VBA. See Why captions are bad for details.

You are having a problem because you are showing the user a query. Users should only have access to forms and reports. They should never see tables or queries. If you simply use your query as the RecordSource for a form or report, you can use whatever value you want in the associated label.