How to get records where field is blank and also record no

[rehanemis]

Hi,

I am trying to get cleanup report of table. I have 8 fields and would like to get report where certain field is blank. I actually also want to get its record no.

Why I need of record no?

Actually i have imported data from Excel sheet that contains about 10,000 records and i would like to make corrections in data in excel and i don't have any unique identifier or needed. So i would like to get record no where certain field is empty.

Hopefully my question makes sense.

Thanks and waiting of your response.

 

[liddlem]

I think you may be able to solve your problem in excel, so I will answer accordingly.

In Excel, you probably want to create a record number before you do anything to your data. so that you can sort the data back to its original order. Add a column called 'Rec_no'. and then use the autofill to number each record.

Now simply sort your data on the column(s) that you want to check.
Do whatever data manipulation need to do.
When you are happy that your data is correct, sort it by Rec_No and then delete that column.

 

[Grumm]

If you don't want to sort, you can still use filters.
In excel you can add filters on the header and select only empty cells.
This method keeps your data in the same order.