still can get this database to count the total for me. i have tried all the sugestion from my last thread but none of them work. it counts for me in my Lot header in my report just fine here is the expression =Int((Count([product])/8)+0.9) it counts that fine and give me a answer but now i want to coun all the answer in the product footer can some one help my head is starting to hurt already and if someone needs to see the report how do i export it and make it into a save file for others to get and view. thx for any help