i' trying to count the records resulting from a query that I run through vba. I'm using the dcount function like this:
intx = DCount("*", SQLstring)
The problem is that the SQLstring is quite long and I get the runtime error 3163:
"the field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data". Any ideas? thanks