ON THIS PAGE: You will find information about how many people are diagnosed with a brain tumor each year and some general survival information. Remember, survival rates depend on several factors. To see other pages, use the menu on the side of your screen.
Finding Duplicate Records. An even more common need is to find duplicates in a table. Perhaps you want to know how many duplicate names there are in the table so you can begin to clean up your data. To do so, create a normal Access Select Query containing the field with duplicate information. The change the query to be an Aggregate Query by clicking the Totals icon in the ribbon. Add one more field, any will do, and then set that field to be Count.. This will give you a count of records that match the name.
You will find some of your [textfield] data chopped off. The Replace function returns a string, so Access is assuming a text type field is appropriate. I don't know why you have to use a select into other than it is easier than creating a table, deleting all the records and then appending the new data. Try creating the result table you want first, so you can make sure both fields are type memo. Then turn your query into an Append (Insert Into) query. You will have to run a Delete query first if you only want the results of this query in the newTable table. Your query as Append: