subreports and link names

  • Thread starter Thread starter Rossz
  • Start date Start date
R

Rossz

I ran across what looks like a bug in Access 2002.

When I attempted to link data fields in a subreport, it would choke on a
field name of "Locations.Route #". It doesn't like the "Locations." part in
the column name, no doubt confusing it with a table name or something.

I can't seen to find a way to treat the whole thing as the column name and
avoid breaking it on the period.

Normally, I'd just modify the query to alias the column to something
else,but a whole bunch of reports use this query so I don't relish the
thought of fixing things up.

A quick and dirty fix was to modify the query to have an additional column
with an acceptable name that contains the exact same data as
"Locations.Route #".
 
So you have two fields with the same name being output in a query. The field
name contains a space and a "#". While this might be a bug, I would suggest
that you take some work on to clean up your object naming and querying.
 
So you have two fields with the same name being output in a query. The
field name contains a space and a "#". While this might be a bug, I
would suggest that you take some work on to clean up your object
naming and querying.
Click to expand...

I didn't create the original database. I would NEVER use odd ball
characters or spaces in column names. While I would love to take the time
to clean up the naming, I doubt the client would want to pay me for the
time required to do so.
 
Back
Top