Adding records from a table and a query

[Guest]

I have two tables..
The first contains contactIDno (autonumber) and other contact info. I would
like to add records to the second table containing mailshot details, by
copying a range of contactIDno's (specified by a query) and then adding other
details, such as date sent, using an update query. Is this at all possible?
I am currently attempting to learn Access, so my experience is limited. I
have no SQL experience. Please help!

 

[Vincent Johns]

I have two tables..
The first contains contactIDno (autonumber) and other contact info. I would
like to add records to the second table containing mailshot details, by
copying a range of contactIDno's (specified by a query) and then adding other
details, such as date sent, using an update query. Is this at all possible?
I am currently attempting to learn Access, so my experience is limited. I
have no SQL experience. Please help!

At least part of it is possible, depending on what other resources you
have. The purpose of an Update query is to copy values into a table
based on what you can calculate based on sources such as other tables.
Unless the "date sent" is already in some location accessible to your
database, possibly it will have to come from some device like (ugh) a
keyboard.

What would be better would be to already have a table somewhere -- if
not in Access, then perhaps in Excel or Word or just plain text -- that
lists the [contactIDno] values and the corresponding [date sent] values.
Since [contactIDno] is something you conjure up out of thin air, I
fear that you don't alreay have such a list on your computer.

Absent a convenient list, my next suggestion would be to set up a
data-entry Form in Access which will display meaningful data about each
contact record (something other than the meaningless [contactIDno]
values; I'd opt for name and employer, maybe sorted by last name) and
allow a knowledgeable person to enter the corresponding new material.
The Form would then store the [contactIDno] value and the new related
data into a table.

After your Tables are populated, you can set up Reports to display or
print summaries of the material they contain.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Guest]

Let me try to explain myself a little better...

One table contains contact ID, geographical location (town or city),
business classification (e.g public houses), and then individual contact info
(such as company name, address etc.)

I then sent information to one geographical area and classification, such as
public houses in Cardiff (there may up to thousands sent).

The second table ( linked to the first via contact ID in a 1 ->many
relationship) contains contact ID, mailshot sent and date sent fields. I may
send to some contacts several times, and so need to add new records each time
i send to that contact.

How could I update the second table, for a specific area and classification
without typing through each record?

If there is an easier way of recording this information, i would be grateful
to learn how!?!

I have two tables..
The first contains contactIDno (autonumber) and other contact info. I would
like to add records to the second table containing mailshot details, by
copying a range of contactIDno's (specified by a query) and then adding other
details, such as date sent, using an update query. Is this at all possible?
I am currently attempting to learn Access, so my experience is limited. I
have no SQL experience. Please help!

At least part of it is possible, depending on what other resources you
have. The purpose of an Update query is to copy values into a table
based on what you can calculate based on sources such as other tables.
Unless the "date sent" is already in some location accessible to your
database, possibly it will have to come from some device like (ugh) a
keyboard.

What would be better would be to already have a table somewhere -- if
not in Access, then perhaps in Excel or Word or just plain text -- that
lists the [contactIDno] values and the corresponding [date sent] values.
Since [contactIDno] is something you conjure up out of thin air, I
fear that you don't alreay have such a list on your computer.

Absent a convenient list, my next suggestion would be to set up a
data-entry Form in Access which will display meaningful data about each
contact record (something other than the meaningless [contactIDno]
values; I'd opt for name and employer, maybe sorted by last name) and
allow a knowledgeable person to enter the corresponding new material.
The Form would then store the [contactIDno] value and the new related
data into a table.

After your Tables are populated, you can set up Reports to display or
print summaries of the material they contain.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.