Re: Voters registration
- From: Sue A. B. <SueAB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 1 Mar 2006 05:31:21 -0800
Thanks Tom - let me clarify - there is only one table, so the addresses are
consistant. Within the table there could be multiple people living at the
same address, but with individual records for each person at the address. I
need to be able to produce mailing labels - one per address - with the names
of all the individuals at that address on the single label - not multiple
labels for the same address. I hope this helps to clarify my problem.
Sue
"Tom Ellison" wrote:
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
- Follow-Ups:
- Re: Voters registration
- From: Jerry Whittle
- Re: Voters registration
- References:
- Re: Voters registration
- From: Tom Ellison
- Re: Voters registration
- Prev by Date: Re: Like query
- Next by Date: Re: Count query
- Previous by thread: Re: Voters registration
- Next by thread: Re: Voters registration
- Index(es):
Relevant Pages
|
