A
Ananth
I am novice in MC Access VBA. If someone can help me in achieving the
following, it will enable me get some momentum in my endeavior of learning
VBA for MS Access Database
I have a huge database of email ids & country to which it is related. Some
common IDs operate in multiple countries. I have created a field COUNT which
willprovide the count of ID in the database., and based on count I would
like to assign Flag M for Multiple & U for Uniqe ID. I WANT to achieve this
only by VBA Programming, though I am very much aware that this can be
achieved by mulriple queries.
ID Country Count Flag
X11 FR 2 M
X12 FR 1 U
X13 FR 1 U
Y11 ES 2 M
Y12 ES 1 U
Y18 ES 1 U
X11 ES 2 M
Y11 UK 2 M
Z11 FR 3 M
Z11 UK 3 M
Z11 FR 3 M
following, it will enable me get some momentum in my endeavior of learning
VBA for MS Access Database
I have a huge database of email ids & country to which it is related. Some
common IDs operate in multiple countries. I have created a field COUNT which
willprovide the count of ID in the database., and based on count I would
like to assign Flag M for Multiple & U for Uniqe ID. I WANT to achieve this
only by VBA Programming, though I am very much aware that this can be
achieved by mulriple queries.
ID Country Count Flag
X11 FR 2 M
X12 FR 1 U
X13 FR 1 U
Y11 ES 2 M
Y12 ES 1 U
Y18 ES 1 U
X11 ES 2 M
Y11 UK 2 M
Z11 FR 3 M
Z11 UK 3 M
Z11 FR 3 M