using access 2000,
i have a table that contains ID number for certain products. The same ID number can be can be entered in the database more than once and I need to
have Access total up the number of records for that certain ID number. In other words when I put the ID number into the form, I want a text box to show me how many records that that ID is in. Hope someone can help me. Thanks alot!