Re: Count and display entries

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello,
I have tried to make each entry the same, so I would not have the issue you
just pointed out.
But, I am glad you pointed that out. Now the code you presented should be
able to handle this...



Thank you,


Charles L. Phillips


DISCLAIMER: This e-mail and any attachments are intended only for the
individual or company to which it is addressed and may contain information
which is privileged, confidential and prohibited from disclosure or
unauthorized use under applicable law. If you are not the intended
recipient of this e-mail, you are hereby notified that any use,
dissemination, or copying of this e-mail or the information contained in
this e-mail is strictly prohibited by the sender. If you have received this
transmission in error, please return the material received to the sender and
delete all copies from your system. The information provided in this and ALL
messages sent is provided as-is. No warranty is provided or implied. Use at
your own risk. All content on these pages has been gathered and compiled by
Charles L. Phillips.
"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:v40qp45p780il1cm0rordkg3n6al0p630n@xxxxxxxxxx
On Wed, 18 Feb 2009 16:42:01 -0800, "Charles L. Phillips"
<tptbusines_2005@xxxxxxxxxxx> wrote:

Hello,
PLEASE, accept my apology for giving a BAD example.
If I entered the address:

218 N. Oak St.
Los Angeles, CA 90012

5 times in the database, I'd like to see how many times I've entered the
address in the database.
I'd like to see that information displayed in/on the form.
I know I can produce that information in a report, I'd like to see the
information displayed in a form view.

What if you have

218 North Oak St., Los Angeles, CA 90012
218 N. Oak Street, LosAngeles, CA 90012
218 North Oak Street, Los Angeles, Cal, 90012

Should that count as three of the same address? It won't. They'll only
count
as matches if they are EXACT, character for character, blank for blank
matches. That said... you can amplify my example using a DCount()
function:

=DCount("*", "[tablename]", "[Address] = """ & [Address] & """ AND [City]
=
""" & [City] & """ AND State= '" & [State] & "' AND Zip = '" & [Zip] &
"'")

Alternatively, especially for the Report, you can create a Totals Query;
include the table's Primary Key (if it doesn't have one, ADD ONE, it's
essential) and the four fields; click the Greek Sigma icon to get the
Totals
row. Leave the default Group By on the four address fields and change it
to
Count on the primary key field.
--

John W. Vinson [MVP]


.