removing blank records

[melhale]

I created a database to print receipts and copy info from excel. Every time
i import new info, i get several blank records before the new info appears.
The receipts are to be in order by receipt #. How can I remove the blanks
without removing those receipt #'s???

Access 2007

 

[Douglas J. Steele]

You could run a Delete query:

DELETE FROM MyTable WHERE SomeField IS NULL

 

[Maarkr]

you could either filter out blanks using a query as your form or report
source ( put a * as criteria in the rec_no field); or you could run a delete
query after the import to delete blanks, like, DELETE * from TblName where
Rec_no is null

 

[melhale]

Thanks - will this keep my receipt numbers in order - if receipt # 12 is
blank and 13 is filled out, would 13 become 12 when i delete 12? I can't
have missing receipt numbers...

 

[Douglas J. Steele]

If you're talking about an AutoNumber field, the answer is no. Gaps will
exist in the numbering.