Re: Voters registration

Dear Sue:

How likely is it, do you think, that the person(s) entering all the
addresses into your database will have typed the same address twice, and
done it exactly the same way?

Do you always use the same State abbreviations? Do you always place 2
spaces after the state abbreviation, then a 5 digit zip? Never use the 9
digit zip? Always use ST and not Street?

The chances of having much success with this are small. If you always use
the 9 digit zip, then you're probably in luck. Just use the name and the 9
digit zip. The post office doesn't really need all the rest of that junk
anyway. Just forget that part. Just:

John Doe
11223-3445

That specifies a single house or apartment. The rest is really unnecessary,
anyway. Wierd, isn't it!

Progress??? We're all just numbers to our government! Soon, my mail will
come to my social security number at my 9 digit zip.

Seriously, though, I think you're in for a rough ride. Can't say for sure
without seeing the data, but I've never seen addresses entered with the kind
of consistency you would seem to require to have even moderate success.

Tom Ellison


"Sue A. B." <Sue A. B. @discussions.microsoft.com> wrote in message
news:0E1F86DB-B809-488C-AC60-8E2F41033C6E@xxxxxxxxxxxxxxxx
I have an Access database(Access 2002) with voter information - first name,
last name, address, city, st, zip. I need to be able to combine records
if
there are more than one person living at the same address to produce
mailing
labels. I also need to combine first names (ie Joe, Mary and John live
at
the same house - the address label should read - Joe, Mary and John
Smith).
Any help is greatly appreciated, I've never done anything like this
before.

Sue


.

Relevant Pages

  • Re: Voters registration
    ... few voters with different last names living at the same address. ... labels for the same address. ... then a 5 digit zip? ... I also need to combine first names (ie Joe, Mary and John live ...
    (microsoft.public.access.queries)
  • Re: Query for Left(String,5) - Access 2007
    ... I think that is more what the OP wants, John, except boston.boston is the 5 ... digit field and Name.zip is the 9 digit version as I read the post. ... Note that this query cannot use the query design view, ... FROM ((boston INNER JOIN Name ON boston.Boston = Name.ZIP) INNER JOIN ...
    (microsoft.public.access.queries)
  • Fwd: Date format search in the file
    ... I will make \- in the regexp compare. ... There is no need to escape a hypen. ... My Regex was incorrect, as John pointed out. ... You only want two digit day values and a 2-4 digit year value so ...
    (perl.beginners)
  • Re: need help with query
    ... think John V. called it right on this. ... are only one digit that are causing the invalid call. ... Don't need a make table query! ...
    (microsoft.public.access.gettingstarted)
  • ask for help
    ... % 'datalabels' should be a Nx1 column vector of labels. ... function [shuffleddata, shuffleddatalabels] = shufflerows ... 'digdata' should be a matrix with 256 elements, ... % Displays the image of the supplied digit. ...
    (comp.soft-sys.matlab)
Loading