Report based on Custom Field data

[Waterscorpion]

I'm trying to generate a report that will display computer information based on Custom Field 10 having data. I thought it would be a fairly simple report, but it seems I must be missing something. I filled two computer's entries with data in this field, and the report captures those fine, but they also appear to be capturing other entries that do not have data in them. It's nowhere close to all of our entries, maybe about 30 of them, but definitely not working the way I'd like. Any advice? Here is the code:

Select Top 1000000 tblComputers.Computer, tblComputers.Username, tblCompCustom.Custom10 As Loaner, tblCompCustom.Custom1 As AssignedTo From tblComputers Inner Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Where tblCompCustom.Custom10 Is Not Null

[Waterscorpion]

Awesome, it worked. Thanks 🙂

[Hemoco · Accepted solution]

Could you try the report below instead.

Select Top 1000000 tblComputers.Computer, tblComputers.Username,
tblCompCustom.Custom10 As Loaner, tblCompCustom.Custom1 As AssignedTo
From tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.Custom10 <> ''