Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
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.
Champion Sweeper III
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.