Recent content by LixPri

Thank you Minty, very much. That worked perfectly and is what I was asking for.

I know how to use DCount. It's the string part and '" that is causing an error and your example for me to read shows no string examples so I can get the quotes correct. This DCount would appear in a text box on a report. Detail of the issue, I am trying to count all the ones in a table...

Access 2010 report. I am trying to use DCount but have a string for the fieldname and cannot figure out the correct syntax. This is what I have tried: txtMiscYes1 = DCount("[" & str1 & "]", "tblTemp", "[" & str1 & "]" = '1') I want to count any answer that has a 1 and skip a 2 or 3...

Hello Access people. I am Lisa. I have been using Access for about 15 years but cannot say I am an expert. Occasionally, I run into something that I really need help with. I am glad there are good people out there that like to help us with our problems so we can get on with it. Thank you in...