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

  • Thread starter Thread starter AccessNeophyte
  • Start date Start date
A

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
 
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)
 
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
..
 
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 -
Click to expand...

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