conflicts in names

L

Larry G

Hello, I have a report using a query involing 3 tables.
When I run it I get an error telling me that there were
conflicting names on the report. What can I do to resolve
this?

Larry
 
F

Fons Ponsioen

Do you man duplicate names in different tables? If so, in
the text boxes on the report, indicate the table in the
source. for instance, if the source data is named data1,
and the table name is Table1 than in the source you would
indicate [Table1.Data1]
Hope this helps (I hope I understood your question
correcly)
Fons
 
M

Marshall Barton

Larry said:
Hello, I have a report using a query involing 3 tables.
When I run it I get an error telling me that there were
conflicting names on the report. What can I do to resolve
this?
Click to expand...


Change the query to eliminate all but one of the duplicated
fields.

If the fields actually have different values, then you
should alias the fields so the report sees different names.
This is done in the query design window by placing the new
name and a colon in fornt of the field. E.g.

field - ListPrice: Price DiscountPrice: Price
table - Inventory OrderDetails
 
Top