Queries doesn't pull the records

[Shiva]

I'm trying to pul the software information on the computer
Name STEPHANO. When i looked in the table STEPHANO have
information about sogftware installed. But I'm unable to
pull the record when I run the query please help me.

SELECT SoftwareInventoryDetails.ComputerName,
SoftwareInventoryDetails.MSDN_License,
SoftwareInventoryDetails.ActionPack_License,
SoftwareInventoryDetails.OEM_License,
SoftwareInventoryDetails.Purchased_License,
SoftwareInventoryDetails.NotLicensed
FROM SoftwareInventoryDetails
WHERE (((SoftwareInventoryDetails.ComputerName)
="ComputerName=STEPHANO"));

 

[Tom Ellison]

Dear Shiva:

Just guessing here, but would this work:

SELECT SoftwareInventoryDetails.ComputerName,
SoftwareInventoryDetails.MSDN_License,
SoftwareInventoryDetails.ActionPack_License,
SoftwareInventoryDetails.OEM_License,
SoftwareInventoryDetails.Purchased_License,
SoftwareInventoryDetails.NotLicensed
FROM SoftwareInventoryDetails
WHERE (((SoftwareInventoryDetails.ComputerName)
="STEPHANO"));

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Shiva]

Hi Tom,
Thanks for replying to my message. But I did not work.
Please let me know any other siggestions.
Thanks

 

[Lynn Trapp]

Try running the query without the where clause to see what values are being
returned in the ComputerName Field. That might help you determine where you
have gone wrong.