conflicts in names

  • Thread starter Thread starter Larry G
  • Start date Start date
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
 
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
 
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
 
Back
Top