removing blank records

  • Thread starter Thread starter melhale
  • Start date Start date
M

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
 
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
 
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...
 
If you're talking about an AutoNumber field, the answer is no. Gaps will
exist in the numbering.
 
Back
Top