Need Help with creating a report

[LithiumKid1976]

hi
Im trying to use the report builder to take a list of machines that have "Microsoft Office Enterprise 2007"


what i want to see in my report is

Computer Name , Software Name, and user name (of the last person to log on to that machine.)

heres what i have set up


Select tblSoftware.ComputerName, tblSoftware.softwareName,
tblUsersInGroup.Username, tblUsersInGroup.Domainname
From tblSoftware Inner Join
tblUsersInGroup On tblUsersInGroup.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName = 'Microsoft Office Enterprise 2007'

when i run it, i get 11 entries for each pc. i.e. picks up all the usernames on the machine.

if anyone could help id appreciate it, as my sql knowledge is very limited, see above query for proof! 🙂
Thanks.

[LithiumKid1976]

Perfect, Thanks a million for that......

[Hemoco]

Try this:

Select tblSoftware.ComputerName, tblSoftware.softwareName,
tblComputers.Userdomain, tblComputers.Username
From tblSoftware Inner Join
tblComputers On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName = 'Microsoft Office Enterprise 2007'