Error Saving a Report ( caption duplication )

[bdirkx]

I have made a report for export functions and when i wan't to save the report i get the error of. Collum Name of Caption must be unique.

This is a sample of my report.

Select Top 100 Percent tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, tblDiskPartition.DeviceID,
tblDiskPartition.Size, tblCDROMDrive.Caption,
tblDisplayControllerConfiguration.Caption,
tblPhysicalMemoryArray.MemoryDevices, tblPhysicalMemory.Capacity,
tblPROCESSOR.Name, tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion
From tblComputersystem Inner Join
tblComputerSystemProduct On tblComputersystem.Computername =
tblComputerSystemProduct.Computername Inner Join
tblDiskPartition On tblComputersystem.Computername =
tblDiskPartition.Computername Inner Join
tblCDROMDrive On tblComputersystem.Computername = tblCDROMDrive.Computername
Inner Join
tblDisplayControllerConfiguration On tblComputersystem.Computername =
tblDisplayControllerConfiguration.Computername Inner Join
tblPhysicalMemoryArray On tblComputersystem.Computername =
tblPhysicalMemoryArray.Computername Inner Join
tblPhysicalMemory On tblComputersystem.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputersystem.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputersystem.Computername =
tblOperatingsystem.Computername

Can annybody tell me whats going wrong.

Greetings

Bart Dirkx

[bdirkx]

thanks it works fine now

[Hemoco]

In the report builder you have a column "alias"

Select Top 100 Percent tblComputersystem.Manufacturer, tblComputersystem.Model,
  tblComputerSystemProduct.IdentifyingNumber, tblDiskPartition.DeviceID,
  tblDiskPartition.Size, tblCDROMDrive.Caption As caption1,
  tblDisplayControllerConfiguration.Caption As caption2,
  tblPhysicalMemoryArray.MemoryDevices, tblPhysicalMemory.Capacity,
  tblPROCESSOR.Name, tblOperatingsystem.Caption As caption3,
  tblOperatingsystem.ServicePackMajorVersion
From tblComputersystem Inner Join
  tblComputerSystemProduct On tblComputersystem.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblDiskPartition On tblComputersystem.Computername =
    tblDiskPartition.Computername Inner Join
  tblCDROMDrive On tblComputersystem.Computername = tblCDROMDrive.Computername
  Inner Join
  tblDisplayControllerConfiguration On tblComputersystem.Computername =
    tblDisplayControllerConfiguration.Computername Inner Join
  tblPhysicalMemoryArray On tblComputersystem.Computername =
    tblPhysicalMemoryArray.Computername Inner Join
  tblPhysicalMemory On tblComputersystem.Computername =
    tblPhysicalMemory.Computername Inner Join
  tblPROCESSOR On tblComputersystem.Computername = tblPROCESSOR.Computername
  Inner Join
  tblOperatingsystem On tblComputersystem.Computername =
    tblOperatingsystem.Computername

[bdirkx]

ok But how do i change the colum names

[Hemoco]

You can several fields with the same name (caption).
You need to give them another name