bv2000

In case anyone is interested, I solved the problem myself by exporting all the records into EXCEL and when asked, I grouped the records by the field that had multiple entries. EXCEL automatically kept only 1 unique entry and deleted all the duplicates. I then opened a new file in FM with the EXCEL data.

i have a database of about 7000 records. Each record is made up of 2 fields - ID# and Date of Svc. Here is my problem: I want to make a mailing list and i must isolate all duplicate ID#. How do I do that. If I use the ! symbol, i must manually delete all entries for an ID# and just leave one. That will take forever. I am sure there is a much easier way to do that. Any help would be very appreciated.

how would i write a script that would always give me tomorrow's appointments. I need a formula that = "today + 1" , but i don't know how to write it ...

how would i write a script that would always give me tomorrow's appointments. I need a formula that = "today + 1" , but i don't know how to write it

I have a database of about 20,000 records I just imported from a .dbf file. I need to have the phone fields show up as (xxx)xxx-xxxx. I have the formula that will work with all new entries, but how do i get it to work on the 20,000 records i just imported. I have tried to write a script, but have been unsuccessful so far.