Originally Posted by
twgonder
@Minty & June7, posts 3-5
Minty? "as you know it's not to return an actual record count." Why not? (never mind, I just read the Allen Browne post)
It's quite possible that another query could pull duplicate field names. That's why, I suppose, that the query builder uses the table names. So why would VBA have problems with the full name (including the table name)? That doesn't make a lot of sense.
In this case, using just the field names worked because there wasn't a duplicate. However, if...?