Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Fill in a blank field in one table from another table

0 views
Skip to first unread message

Jeff Shoaf

unread,
Jan 25, 2001, 11:04:46 AM1/25/01
to
You should be able to link using the territory number. Use a changeTo query
to put the zip code in the imported table:

zipTable | ZipCode | Territory Number |
| _join1 | _territory |

importTable | ZipCode | Territory Number |
| _join1 | changeto _territory |

Note that this assumes that the corresponding fields in each table are of
the same type.

Jeff D. <le...@tmemail.com> wrote in message
news:01c086e7$b28fa6a0$1001...@node12.dsl.net...
> I have a table that needs one field filled in. The field is "Territory
> Number." By typing in the zipcode for each record (in the "zipcode
> field")...the territory number field will be filled in. It is pulled from
> another table (zipcode table).
> Problem: I have imported 140 leads into a table. The territory number is
> missing from each record. I am trying to run a query that will pull the
> territory number from one table (zipcode table) & insert the territory
> number into the appropriate field in the table that I imported. The
> territory number is found in the zipcode table. Each zipcode is assigned a
> territory number.
>
> Question: How do I run a query that will pull the territory number from
the
> zipcode table & insert it in the territory field in my imported table? The
> common field (to join?) is zipcode field.
>
> thank you,
>
> Jeff Dollman


Jeff D.

unread,
Jan 25, 2001, 10:54:06 AM1/25/01
to

Jeff D.

unread,
Jan 25, 2001, 11:35:13 AM1/25/01
to
Jeff: This fills in the field with the text "ter", not the territory
number. Query attached.
Query
ANSWER: :PRIV:ANSWER.DB

Tsuzips.DB | ZIP CODE | TERRITORY NUMBER |
| _join1 | territory |

Usreg.DB | Zipcode | Territory Number |
| _join1 | changeto territory |

EndQuery

Any other suggestions?

Jeff D.


Jeff Shoaf <jsh...@gateway.net> wrote in article <3a704ee6@cnews>...

Dennis Santoro

unread,
Jan 25, 2001, 12:25:33 PM1/25/01
to
Try (note the new _ chars):

Query
ANSWER: :PRIV:ANSWER.DB

Tsuzips.DB | ZIP CODE | TERRITORY NUMBER |

| _join1 | _territory |

Usreg.DB | Zipcode | Territory Number |
| _join1 | changeto _territory |

EndQuery

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
375 High Street
Rochester, MA 02770
(508) 295-7350
and
Waldweg 5
83512 Reitmehring
Germany
08071 924271
Providing solutions to health care, business, governments and non-profits since
1982

Jeff D.

unread,
Jan 25, 2001, 12:32:58 PM1/25/01
to
What does the _mean?

thank you,

Jeff D.

Dennis Santoro <RDA...@RDAWorldWide.com> wrote in article
<3A70618D...@RDAWorldWide.com>...

Jeff D.

unread,
Jan 25, 2001, 1:04:59 PM1/25/01
to
I looked in the book. It works!!!!

Thank you very much!

Jeff D. <le...@tmemail.com> wrote in article
<01c086f5$820d67c0$1001...@node12.dsl.net>...

Dennis Santoro

unread,
Jan 25, 2001, 12:36:57 PM1/25/01
to
Example element, just like _join1.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
375 High Street
Rochester, MA 02770
(508) 295-7350
and
Waldweg 5
83512 Reitmehring
Germany
08071 924271
Providing solutions to health care, business, governments and non-profits since
1982

Jeff Shoaf

unread,
Jan 25, 2001, 1:11:27 PM1/25/01
to
Yup - the underscores are very important!

Jeff D. <le...@tmemail.com> wrote in message
news:01c086f9$fabddf20$1001...@node12.dsl.net...

0 new messages