Re: Passing the output of a query to a table

Post the layout of all involved tables. Indicate key fields. You can omit
fields which are not involved.

"Mark" <markrichardfoster@xxxxxxxxxxx> wrote in message
news:%23SHZ6OaXIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
As far as I can tell I am not attempting to save the data twice.

I have a group of linked reference tables that contain competency
information split into: Unit - Cluster - Element - Criteria.

One employee has a quarterly review. Each review contains 3 units, each
unit contains several clusters etc... (see very bottom of page)

I am using the query to pull up a list of criteria based on the Element. I
am aiming to copy this criteria code (1.1.1.1 etc) into a record list
linked to the employees ID. From there I can then attribute a value (eg
Good, Bad, N/A) to each criteria.

I hope that clarifies the situation a little more?

Many thanks

"Robert" <cpq1bcle[REMOVE]@verizon.net> wrote in message
news:47969c1f$1$4042$bbae4d71@xxxxxxxxxxxxxxxxxxxxxx
It sounds like you are trying to save the same information twice. And
you don't need to do that.

Tables are for saving data. Queries are for looking at data. One table
can be called in more than one / many different queries. The results of
these queries do not need to be saved.

Robert

"Mark" <markrichardfoster@xxxxxxxxxxx> wrote in message
news:eG3%23TQQXIHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
Hello

I am attempting to create an employee competency database and have been
on a steep learning curve.
I am at the point where I have created a query that will filter the
individual performance criteria into a subform.
What I am now attempting to do is to pass some values from one column in
the query output, into a pre-existing table, with each row from the
query output creating a new row in the records table.

I hope that makes sense?

Below is an idea of the structure. The tbl_ReviewContent &
tbl_Element_Criteria_Subform both save to one table (called
ReviewContent)

Any help is greatly appreciated.

Mark



tbl_ReviewHeader:
ReviewID (autonumber)
Employee_ID (lookup from tbl_employee)
JobTitle (lookup from tbl_jobs)
ReviewPeriod (lookup from tbl_reviewperiod)

tbl_ReviewContent:
ReviewContentID (autonumber)
ReviewID (linked to tbl_ReviewHeader)
Unit (combo selection)
Cluster (combo selection)
Element (combo selection)

tbl_Element_Criteria_Subform:
Criteria
Rating
Notes

The competencies are linked on a one to many basis e.g.

Unit = 1
Cluster = 1.1 (1.2, 1.3, 2.1 etc)
Element = 1.1.1 (1.2.1, 1.3.1, 2.1.1 etc)
Criteria = 1.1.1.1 (1.2.1.1, 1.3.1.1, 2.1.1.1 etc)











.

Relevant Pages

  • Re: Passing the output of a query to a table
    ... One employee has a quarterly review. ... I am using the query to pull up a list of criteria based on the Element. ... I am attempting to create an employee competency database and have been ... query output creating a new row in the records table. ...
    (microsoft.public.access.queries)
  • Re: Healthcare in Canada
    ... criteria, and likely would have been overturned by the review board. ... Shame is the girl did not have that kind of time... ... the criteria have been open to review for years. ... claim they want, or pay only a portion, and you have the right to appeal ...
    (alt.smokers.cigars)
  • Re: AllMusic reviews "Love"
    ... And who WOULDN'T praise it by that criteria? ... wildly innovative mashup and a "new" product...even though the ... I remember reading a review of SKYLARKING... ... ....que sera, sera. ...
    (rec.music.beatles)
  • Re: Passing the output of a query to a table
    ... One employee has a quarterly review. ... I am using the query to pull up a list of criteria based on the Element. ... I am attempting to create an employee competency database and have been ...
    (microsoft.public.access.queries)