J
John Spencer
Both my wife and I fall into your user age range. I don't see how
having input "fields" for
Last Name
First Name
Street Address
City
State
ZIP Code
would confuse anyone that is used to filling out paper forms that do the
same thing. If that simple structure confuses people then you are bound
to get junk in your current web input and resolving that would be close
to impossible.
I guess you could make a lot of assumptions, but you are going to have
to have someone review every entry if you want any degree of accuracy.
If you will send me a few samples of the data before transferring it to
your normalized data structure AND your data structure, I will see if I
can write some VBA routines that might help.
You can use S_PENCERFour at Comcast. NET . xRay
Change the four to a number, drop the spaces and drop everything after
NET. Also remove the underscore.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
having input "fields" for
Last Name
First Name
Street Address
City
State
ZIP Code
would confuse anyone that is used to filling out paper forms that do the
same thing. If that simple structure confuses people then you are bound
to get junk in your current web input and resolving that would be close
to impossible.
I guess you could make a lot of assumptions, but you are going to have
to have someone review every entry if you want any degree of accuracy.
If you will send me a few samples of the data before transferring it to
your normalized data structure AND your data structure, I will see if I
can write some VBA routines that might help.
You can use S_PENCERFour at Comcast. NET . xRay
Change the four to a number, drop the spaces and drop everything after
NET. Also remove the underscore.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================