Why does my query put brackets around some fields from my table and not others?

[AccessNeophyte]

Greetings All,

I have set up a query to use for a report. When I "drag&drop" most of
the fields from the table, they look the way they do in the table.
But some get brackets around them in the query. I can't see any
difference between these fields in the table, except in the Field Size
property ( the ones that get brackets are 255, whereas the oithers are
50).

Any ideas?

Thanks,
Liz

 

[Steve]

If your field names have spaces, they will get brackets.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Spencer]

Field names and table names that have spaces in them require the brackets
and field names and tables names that have characters other than A-z, 0-9,
or underscore usually require brackets around them. Also field names with
just number characters require the brackets.

X-y as a field name could also be interpreted as subtract field y from field
x
1 could be a number value or a field name
aa*bb could mean multiply field aa times field bb



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[AccessNeophyte]

Field names and table names that have spaces in them require the brackets
and field names and tables names that have characters other than A-z, 0-9,
or underscore usually require brackets around them. Also field names with
just number characters require the brackets.

X-y as a field name could also be interpreted as subtract field y from field
x
1 could be a number value or a field name
aa*bb could mean multiply field aa times field bb

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.









- Show quoted text -

Thanks guys! It was the special characters. Once I removed them, it
looked and ran fine.