My query is summing records based on a priority field value (1, 2, or 3) and may find none. When there are no records that meet the criteria for a given priority the line that updates the textbox with the value errs out (below).
here is my code for the textbox:
Expand|Select|Wrap|Line Numbers
- Me.txt_low_cnt = Nz((db.OpenRecordset(strSQL)(0)) & " ", "0")
Thanks for any ideas.