Checking data in many tables

[Guest]

I have a table called Active with the field Part_Num. I have a table called
Inquiry with the fields Part_Num and Effective_Date.

I want to take the Part_Num from Active and if it is found in Inquiry (which
it could find it more than once and I want all of the results) I want it to
add a record to my Result table populating the Part_Num and Effective_Date
fields.

 

[Jeff Boyce]

I'm not visualizing your data structure, but it sounds like you are trying
to write the same data into more than one table. If so, why?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I have a list of parts that are active on a project. That is my Active
table. Then, I have a list of every time we updated that particular part so
the part number shows up multiple times. I want to pull all of the times we
updated a part if it is in the Active table from the Inquiry table (where the
updates are listed).

 

[Jeff Boyce]

I believe I understand the [Active] and [Inquiry], but why write to a
[Result] table?

If you want all [Inquiry] date/times for each part in the [Active] table,
I'm thinking a query joining those two tables will return the data you're
describing. No need to write it anywhere, since the query can be used to
feed a form or a report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I actually do need it in a new table. Can you help?

I believe I understand the [Active] and [Inquiry], but why write to a
[Result] table?

If you want all [Inquiry] date/times for each part in the [Active] table,
I'm thinking a query joining those two tables will return the data you're
describing. No need to write it anywhere, since the query can be used to
feed a form or a report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a list of parts that are active on a project. That is my Active
table. Then, I have a list of every time we updated that particular part
so
the part number shows up multiple times. I want to pull all of the times
we
updated a part if it is in the Active table from the Inquiry table (where
the
updates are listed).

 

[Jeff Boyce]

I'm not asking to be rude, or to pry. I'm asking because it is unusual to
need a table that duplicates data you can already come up with through a
query. What is it that you intend to do with the "new table"?

And if you're convinced that you need a new table, or don't wish to describe
the business need, take a look at converting the query that builds the list
of date/times for Active parts (see previous response) to a "Make Table"
query (Access HELP can help).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I actually do need it in a new table. Can you help?

I believe I understand the [Active] and [Inquiry], but why write to a
[Result] table?

If you want all [Inquiry] date/times for each part in the [Active] table,
I'm thinking a query joining those two tables will return the data you're
describing. No need to write it anywhere, since the query can be used to
feed a form or a report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a list of parts that are active on a project. That is my Active
table. Then, I have a list of every time we updated that particular
part
so
the part number shows up multiple times. I want to pull all of the
times
we
updated a part if it is in the Active table from the Inquiry table
(where
the
updates are listed).

:

I'm not visualizing your data structure, but it sounds like you are
trying
to write the same data into more than one table. If so, why?

Regards

Jeff Boyce
Microsoft Office/Access MVP


I have a table called Active with the field Part_Num. I have a table
called
Inquiry with the fields Part_Num and Effective_Date.

I want to take the Part_Num from Active and if it is found in
Inquiry
(which
it could find it more than once and I want all of the results) I
want
it
to
add a record to my Result table populating the Part_Num and
Effective_Date
fields.

 

[Guest]

I don't have a query to build the active part list. Is it possible for you
to trust me that I do in fact need the information populated to a new table?
I need the new table because I'm reformatting previously formatted data and
adding more information to the new table to use the new table as a new
reference.

If you just wanted to pick apart my question instead of helping me with the
code you could have saved us both time and left no responce.

I'm asking for help with this. I would appreciate it if you took the time.

I'm not asking to be rude, or to pry. I'm asking because it is unusual to
need a table that duplicates data you can already come up with through a
query. What is it that you intend to do with the "new table"?

And if you're convinced that you need a new table, or don't wish to describe
the business need, take a look at converting the query that builds the list
of date/times for Active parts (see previous response) to a "Make Table"
query (Access HELP can help).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I actually do need it in a new table. Can you help?

I believe I understand the [Active] and [Inquiry], but why write to a
[Result] table?

If you want all [Inquiry] date/times for each part in the [Active] table,
I'm thinking a query joining those two tables will return the data you're
describing. No need to write it anywhere, since the query can be used to
feed a form or a report.

Regards

Jeff Boyce
Microsoft Office/Access MVP


I have a list of parts that are active on a project. That is my Active
table. Then, I have a list of every time we updated that particular
part
so
the part number shows up multiple times. I want to pull all of the
times
we
updated a part if it is in the Active table from the Inquiry table
(where
the
updates are listed).

:

I'm not visualizing your data structure, but it sounds like you are
trying
to write the same data into more than one table. If so, why?

Regards

Jeff Boyce
Microsoft Office/Access MVP


I have a table called Active with the field Part_Num. I have a table
called
Inquiry with the fields Part_Num and Effective_Date.

I want to take the Part_Num from Active and if it is found in
Inquiry
(which
it could find it more than once and I want all of the results) I
want
it
to
add a record to my Result table populating the Part_Num and
Effective_Date
fields.

 

[Jeff Boyce]

Please re-read my previous response. Use a Make Table query to generate a
new table based on existing table data.

I was attempting to learn enough about what you want to achieve (not HOW you
want to achieve it) to provide useful feedback. I went out of my way to
explain that I wasn't being rude or prying. It isn't a matter of "trust"
.... I just hadn't learned enough to provide more complete suggestions.

Best of luck!

Jeff Boyce
Microsoft Office/Access MVP

I don't have a query to build the active part list. Is it possible for you
to trust me that I do in fact need the information populated to a new
table?
I need the new table because I'm reformatting previously formatted data
and
adding more information to the new table to use the new table as a new
reference.

If you just wanted to pick apart my question instead of helping me with
the
code you could have saved us both time and left no responce.

I'm asking for help with this. I would appreciate it if you took the
time.

I'm not asking to be rude, or to pry. I'm asking because it is unusual
to
need a table that duplicates data you can already come up with through a
query. What is it that you intend to do with the "new table"?

And if you're convinced that you need a new table, or don't wish to
describe
the business need, take a look at converting the query that builds the
list
of date/times for Active parts (see previous response) to a "Make Table"
query (Access HELP can help).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I actually do need it in a new table. Can you help?

:

I believe I understand the [Active] and [Inquiry], but why write to a
[Result] table?

If you want all [Inquiry] date/times for each part in the [Active]
table,
I'm thinking a query joining those two tables will return the data
you're
describing. No need to write it anywhere, since the query can be used
to
feed a form or a report.

Regards

Jeff Boyce
Microsoft Office/Access MVP


I have a list of parts that are active on a project. That is my
Active
table. Then, I have a list of every time we updated that particular
part
so
the part number shows up multiple times. I want to pull all of the
times
we
updated a part if it is in the Active table from the Inquiry table
(where
the
updates are listed).

:

I'm not visualizing your data structure, but it sounds like you are
trying
to write the same data into more than one table. If so, why?

Regards

Jeff Boyce
Microsoft Office/Access MVP


message
I have a table called Active with the field Part_Num. I have a
table
called
Inquiry with the fields Part_Num and Effective_Date.

I want to take the Part_Num from Active and if it is found in
Inquiry
(which
it could find it more than once and I want all of the results) I
want
it
to
add a record to my Result table populating the Part_Num and
Effective_Date
fields.