Based on a blind guess of the data from the lack of DDL, you can drop
the NULLs with just:
SELECT computer_name, ip_address, form_title, MAX(file_date)
FROM PortChecker
GROUP BY computer_name, ip_address, form_title;
Data elements should not change names names in queries, nor should
those names have blanks in them. It looked as if you were doing
display formatting in the database and not the front end.
the NULLs with just:
SELECT computer_name, ip_address, form_title, MAX(file_date)
FROM PortChecker
GROUP BY computer_name, ip_address, form_title;
Data elements should not change names names in queries, nor should
those names have blanks in them. It looked as if you were doing
display formatting in the database and not the front end.