Re: Passing the output of a query to a table

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: Query Criteria Help!!!
    ... It would be better if I could run a report on this information. ... review process is closed at that date). ... > A work around for your query is as follows. ... > Use the QBE query grid and in the first row of the criteria completed 1 ...
    (microsoft.public.access.queries)
  • RE: Linking a Combo box to variable SQL query in subform
    ... to pass a criteria to a query from a form; you need to reference the correct ... Form control in the query's criteria: ... tbl_ReviewHearder, the second, ...
    (microsoft.public.access.forms)
  • Re: Date query
    ... In your query make another column like ... DayDifference: -now ... In the criteria section of that column use ... > people are coming up on their review dates. ...
    (microsoft.public.access.queries)
  • Re: date problem
    ... > after three months i want to review the record and enter a review date ... > i now query the table adding a fieldthat takes the review date ... criteria in the calculated field it appears to work correctly. ...
    (comp.databases.ms-access)