I'm really confused about your updated code. You have an empty select statement, then a count statement in a separate recordset. I'm not sure what you are trying to do here, but the approach seems wrong. We may need to have a phone conversation and screen sharing so I can understand what you are trying to do and suggest the right way to go about it.