by Stuart Meie » Thu, 26 Sep 2002 08:45:30
TIA
by remove EATSPAM to repl » Thu, 26 Sep 2002 12:50:08
Why not just check the addresses also? Or are the addresses differentQuote:> I've got my head "up & locked" !
> I have a database of students with addresses. I want to mail ONLY 1
per
> family. I can get the list with a query-by-example, by only "clicking-
> green checkmark" on the Lastname.....BUT How do I then get the
addresses
> ?
--KC
by David Farme » Fri, 27 Sep 2002 01:06:33
by Stuart Meie » Fri, 27 Sep 2002 12:10:56
> Why not just check the addresses also? Or are the addresses different
> somehow?
> --KC
by Steve Urbac » Sat, 28 Sep 2002 00:59:11
>> > I've got my head "up & locked" !
>> > I have a database of students with addresses. I want to mail ONLY 1
>> per
>> > family. I can get the list with a query-by-example, by only "clicking-
>> > green checkmark" on the Lastname.....BUT How do I then get the
>> addresses
>> > ?
>> Why not just check the addresses also? Or are the addresses different
>> somehow?
>> --KC
by Stuart Meie » Sat, 28 Sep 2002 09:53:33
> >If I click on the addresses, I'll get multiple labels for 1 family. I only
> >wnat the list 1 have 1 label per family.
> >> > I've got my head "up & locked" !
> >> > I have a database of students with addresses. I want to mail ONLY 1
> >> per
> >> > family. I can get the list with a query-by-example, by only "clicking-
> >> > green checkmark" on the Lastname.....BUT How do I then get the
> >> addresses
> >> > ?
> >> Why not just check the addresses also? Or are the addresses different
> >> somehow?
> >> --KC
> ---
> , _
> , | \ MKA: Steve Urbach
> , | )erek No JUNK in my email please
> , / / /
> Running United Devices "Cure For Cancer" Project 24/7
> Have you helped? Http://www.ud.com
by Steve Urbac » Sat, 28 Sep 2002 10:32:07
Then take the easy way out and don't check the name at all.Quote:>I don't care. The only spec is 1 to a family.
K.I.S.S. wins
Steve U
>> Say you have 3 Family members... What determins *who* gets their name
>> on the label?
>> Steve U
>> >If I click on the addresses, I'll get multiple labels for 1 family. I only
>> >wnat the list 1 have 1 label per family.
>> >> > I've got my head "up & locked" !
>> >> > I have a database of students with addresses. I want to mail ONLY 1
>> >> per
>> >> > family. I can get the list with a query-by-example, by only "clicking-
>> >> > green checkmark" on the Lastname.....BUT How do I then get the
>> >> addresses
>> >> > ?
>> >> Why not just check the addresses also? Or are the addresses different
>> >> somehow?
>> >> --KC
>> ---
>> , _
>> , | \ MKA: Steve Urbach
>> , | )erek No JUNK in my email please
>> , / / /
>> Running United Devices "Cure For Cancer" Project 24/7
>> Have you helped? Http://www.ud.com
by Sundial Service » Sat, 28 Sep 2002 11:18:47
The first pass might be to select the possible list of addresses, ignoring
dupes at this point.
Then sort the list by address. Dupes will be instantly visible because they
will now be adjacent (assuming the data has been cleaned up, e.g. "St." is
consistently capitalized and used to refer to "Street" and so on).
A short script might be used to do the work now, copying the records into a
final list and remembering the last record copied, filtering out the dupes
as it encounters them.
Does this give some ideas?
by Stuart Meie » Mon, 30 Sep 2002 10:36:12
> The first pass might be to select the possible list of addresses, ignoring
> dupes at this point.
> Then sort the list by address. Dupes will be instantly visible because they
> will now be adjacent (assuming the data has been cleaned up, e.g. "St." is
> consistently capitalized and used to refer to "Street" and so on).
> A short script might be used to do the work now, copying the records into a
> final list and remembering the last record copied, filtering out the dupes
> as it encounters them.
> Does this give some ideas?
> > I've got my head "up & locked" !
> > I have a database of students with addresses. I want to mail ONLY 1 per
> > family. I can get the list with a query-by-example, by only "clicking-
> > green checkmark" on the Lastname.....BUT How do I then get the addresses
> > ?
> ----------------------------------
> Fast automatic Paradox table repair at a click of a mouse!
> http://www.sundialservices.com/products/chimneysweep
by Stuart Meie » Mon, 30 Sep 2002 10:36:46
> >I don't care. The only spec is 1 to a family.
> Then take the easy way out and don't check the name at all.
> Address all to "Occupant" at street address
> K.I.S.S. wins
> Steve U
> >> Say you have 3 Family members... What determins *who* gets their name
> >> on the label?
> >> Steve U
> >> >If I click on the addresses, I'll get multiple labels for 1 family. I only
> >> >wnat the list 1 have 1 label per family.
> >> >> > I've got my head "up & locked" !
> >> >> > I have a database of students with addresses. I want to mail ONLY 1
> >> >> per
> >> >> > family. I can get the list with a query-by-example, by only "clicking-
> >> >> > green checkmark" on the Lastname.....BUT How do I then get the
> >> >> addresses
> >> >> > ?
> >> >> Why not just check the addresses also? Or are the addresses different
> >> >> somehow?
> >> >> --KC
> >> ---
> >> , _
> >> , | \ MKA: Steve Urbach
> >> , | )erek No JUNK in my email please
> >> , / / /
> >> Running United Devices "Cure For Cancer" Project 24/7
> >> Have you helped? Http://www.ud.com
> ---
> , _
> , | \ MKA: Steve Urbach
> , | )erek No JUNK in my email please
> , / / /
> Running United Devices "Cure For Cancer" Project 24/7
> Have you helped? Http://www.ud.com
by Steve Urbac » Mon, 30 Sep 2002 11:08:27
If you check only [address], [city], [state], [zip]Quote:>But I can't have Dupe addresses
1234 S. Fifth St
is not the same as
1234 S Fifth St
BTW I don't know of any single query that will eliminate my example
problem. You might do some "quick and dirty" scripts to standardize
the data.
Steve U
>> >I don't care. The only spec is 1 to a family.
>> Then take the easy way out and don't check the name at all.
>> Address all to "Occupant" at street address
>> K.I.S.S. wins
>> Steve U
>> >> Say you have 3 Family members... What determins *who* gets their name
>> >> on the label?
>> >> Steve U
>> >> >If I click on the addresses, I'll get multiple labels for 1 family. I only
>> >> >wnat the list 1 have 1 label per family.
>> >> >> > I've got my head "up & locked" !
>> >> >> > I have a database of students with addresses. I want to mail ONLY 1
>> >> >> per
>> >> >> > family. I can get the list with a query-by-example, by only "clicking-
>> >> >> > green checkmark" on the Lastname.....BUT How do I then get the
>> >> >> addresses
>> >> >> > ?
>> >> >> Why not just check the addresses also? Or are the addresses different
>> >> >> somehow?
>> >> >> --KC
After upgrading to D3 for SCO, the list-label and sort-label command jumps
up 3 lines after the 24th label on a 4up label setting (between the 4th and
5th row). It's not the printer, the jump appears in hold files as well.
And no matter how many labels you print, it only jumps the 1 time between
the 4th and 5th row. We have been using the printer and command settings
for the list-label command for years.
If anyone has the same problem and has solved it, please let me know. We
are currently printing 24 dummy labels prior to the jump so that the
regular label run won't be ruined.
Thanks
2. Access 2.0 Attached to SQL HELP !!!
3. Selecting items in a DB-list and passing fields from selected rec to a control
6. Oracle Clinical (Comments)?
7. Fill Combo List using Criteria selected in another Combo List
8. DTS Examples
9. Updating a combo box list W/limit to list selected
10. Fill Combo List using Criteria selected in another Combo List
11. Toggling Between List Boxes at the Same Location and Selecting Records in Each List Box
12. DataReport and mailing label list
13. Mailing Labels from List Box Selections?