Can I have a space in field name?

[Ai_Jun_Zhang]

Hi!

Is it possible for me to alias the fldGroup to Function Group?

How do you alias a field name to a name that contain a space?

Please advise.

Aijun.

 

[Mile-O]

In a query, select the field you want and it drops into the query design grid.

Replace fldGroup with:

Function Group: [fldGroup]

 

[maxmangion]

rather than using an alias for the fieldname, you can also consider using the Caption property.

 

[Pat Hartman]

I would not alias a field name in a query to include spaces. That defeats the purpose. It sounds like you intend to use the query itself as the presentation. I don't recomend that. Make a form or report with that query as the RecordSource. You will have a lot more flexibility and will be able to better control what the user does with the data. In a form or report, you can use whatever you want in the labels for each control.

PS - see this post to learn Why I don't use captions!!
link fixed