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.
Add a range of fields from the Field List pane to the form or report by doing the following: Click the first field in the range. Press and hold the SHIFT key, and then click the last field in the range. Access selects the fields you clicked, as well as all the fields in between.ote If the database does not contain any tables, the Field List pane is empty. When you find the field you want to add, do one of the following to add it to the form or report: Double-click the field. Drag the field from the Field List pane to the form or report.