Removing unnecessary Fields

[Ballistic P]

I imported a column from Excel into my database which had about 250 entries (no problems with that part) but when I scroll through the 250 entries in the FMP Database there are about 2500 additional blank pages tacked on at the end (pages 251 & on). Is there a way to clean up the DB and remove all the blank pages so my people are only able to scroll through the 250 that have information?

Sorry for the ignorant question here...

[Fenton]

Do you mean extra "pages," in Preview mode, or do you mean extra records? If it's records, it's because you imported blank rows from Excel (easy to do). In that case you can just delete them, if they're truly empty.

If it's pages, then you're seeing a bug. In Preview I would see thousand (and hundreds of thousands) of pages, though it would always print correctly. Weird. I was seeing this earlier, on both platforms, but haven't lately. They may have fixed it in 7.0v3, which you defintely should update to if you haven't.

[Ballistic P]

Fenton,

Actually, I see them in both Preview and Browse mode. I do want to get rid of them (since they are not being used) but there is about 3000 extra pages. Is there a way to mass delete them rather then sitting there for 12 hours deleting them one by one?

I haven't done the update yet but am downloading now.

BTW, I was in your neck of the woods last week, beautiful area.

[QuinTech]

To find all records with no data in them, enter find mode and put an = in each field. Once found, from the Records menu select Delete Found Records.

Jerry

[Lee Smith]

Hi Ballistic,

I responded with this response yesterday, and then deleted it because Fenton had posted his response while I was composing mine. After reading his post, I read your post again, and I decided I'd wait to see if he had nailed the problem. In the mean time, I see you responded and Jerry has posted part of what my response was going to be. Sorry Jerry, no echo today, I just not going to modify it again.

Lee

You can do this a couple of ways.

If you know for sure that there are *no* data in the records above record number 250, do a Find for all records [color:"blue"]Go to Menu >> Records >> Show All Records Ctrl+J . Next, Go to [color:"blue"]Menu >> Records >> Omit Multiples, and enter 250 in the dialog box window, and then hit then the "OMIT" button. Then go back to the [color:"blue"]Menu >> Records >> Delete Found Records, Hit the "Delete All" button.

or

If you want to ensure that only the first 250 records have data, then I would suggest that you follow Jerry's method, and do a find on each field using the = sign.

HTH

Lee

[Ballistic P]

Jerry & Lee, Perfect! Thank you for the support and it has resolved my problem!!

Thanks you everyone for the help.

Ballistic