Need to find a data in table.

[kat25]

I have a table that has old data as well as newly inputted data. The table is named FIBER. The field name is named CABLE and the other field name is NUMBER. I want to find every record that has a value loaded in the CABLE field and then list the value of what is shown in the NUMBER field in that record.

I'm trying to find which records are old data and which records have been newly inputted into the table.

Thank you.
Kat

 

[dhookom]

Try create a query with this SQL view:

SELECT [NUMBER]
FROM [FIBER]
WHERE [CABLE] Is Not Null;

Duane
Hook'D on Access
MS Access MVP