Hello. Thanks to you who have taken the time to check out my question. Thanks in advance for those who might be able to help.
I'm a complete novice! I've played with Access to track my personal buisness needs. I made the mistake to show my boss what i could do. Next think you know, i'm the resdient specialist in Databases!
So, I have a problem that I can't figure out.
The attached is a copy of a table that I have. Several columns are multi value fields - as you can plainly see.
I'm trying to do a 'Dcount' on each id number in each multivalued field to show on a report. I wrote my dcount like:
=dcount("[ConnectID]","test03","tap to ground=3") All i get is an error
But--when i write the query on a NON multivalued field, I get a good result. ie:
=dcount("[ConnectID]","test03","COD >0" Good result!
is there another way, in ACCESS to get a record count based on a parameter for a multi valued field?