Custom Field 1 Report issue

[ngriesbach]

I have about 1000 PCs im trying to report on. In Custom Field 1 ive renamed it to EOL (End of Life) in Date format. The point of this is for me to build a report to determine which PCs I need to replace each month. Could someone assist in helping me build a report to tell me if any PCs dont have the the date inputted yet and also a report with a list of PCs with it inputted? I keep attempting to build one but im not getting the data im looking for.



Thank you for your time.

[AZHockeyNut]

show us a sample of a report you tried?

you probably need (tblassetcustom.custom1 is NULL) in your where clause to get you the ones that have no value.

you may also need something like this to weed out whitespace versus null

SELECT column_name
FROM table_name
WHERE TRIM(column_name) IS NULL

older versions of sql were LTRIM() or RTRIM() if I recall.