subreports and link names

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

 

[Duane Hookom]

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.