Queries doesn't pull the records

  • Thread starter Thread starter Shiva
  • Start date Start date
S

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"));
 
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
 
Hi Tom,
Thanks for replying to my message. But I did not work.
Please let me know any other siggestions.
Thanks
 
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.
 
Back
Top