Column names in each view must be unique

[andymorris]

Just trying to create a report that includes the Asset Description from tblAssets1 and also computer Description from tblAdComputers but I get an error saying that the column names in each view must be unique and I cannot save the report until I remove one of the descriptions.


Is there any way to get both these fields to display?

Thanks


Andy

[stiwa · Accepted solution]

You have to set an alias for one Description column.