Purging data from a table

[orange]

I have no idea what you are describing.

When you Delete a record, the entire record is removed. What are the "spaces' you are talking about?

[normie]

What I mean is I deleted data in Row/Record 1 to 28 but Rows 1 to 28 still exsist but with no data in them...I want to delete the data and the empty rows at the same time which would allow the remaining data to start at Row / Record 1

[orange]

Please show the table definition. If you are saying you had a table and that table has a number of fields, and 1 of those fields is an autonumber datatpye and you had records 1-28. Once you deleted the records, if you try to add a new record, that record will have autonumber 29 (or some other unique number).
If you empty (Delete all records) a table with an autonumber, you can reset the autonumber if you run Compact and Repair.
Otherwise those numbers will be considered used.

I really don't understand exactly what you have.

[normie]

I took the autonumber out and changed it to Date/Time

[orange]

We are just NOT on the same wave length. Based on you last pdf, you need to structure your tables. You should research Normalization.
Getting your tables and relationships correct (to truly represent what you are dealing with and the associated rules) is key to database.
You will work for hours trying to work around things with special programs and conditions if you don't get the tables and relationships set up.

Are you also saying that you did have an autonumber field as I had guessed? Did you do a compact repair? How many records in your table now?

[normie]

Success!!! The compact on close did the job....I think the reason we were not on the same page is this database is not that complex and I could not explain to the level of your knowlege
Thanks for your help
I might (probobaly) be back

[orange]

Glad you got it working. Getting table structures correct is the biggest part of database. Many problems can be related to table structures.