calculation field in a query and lookup tables?

  • Thread starter Thread starter King Kaos
  • Start date Start date
K

King Kaos

I'm new with using the whole query thing. However, I have a table that I
can put various score for an intelligence test (the test is broken into
eleven different score) I have a calculation field in my query that adds up
these fields (the raw score) and I then this calculation field is linked to
a lookup table to obtained the IQ score (standard score) and various
confidence level. However, when I link this table to the calculation field
in the query I am unable to input any data and have to remove the table to
get the query to work in my form. I have a feeling this is something simple
that I am doing wrong.



Thanks



Keith
 
The query is a "totals" query, meaning that you're using aggregate function
in it to get the sum. All such queries are nonupdatable, even if they're not
the "query/table" that you want to edit -- so long as they're part of your
final query, that final query is nonupdatable.

Two possibilities:

Put the results of the first query into a table and then use the table as a
linking table in the final query.

Use the DSum function in the final query to get the "sum" value that the
first query gives you (note that this may be slow if there are a lot of
records).
 
You can convert that query into a MAKE TABLE query. Open the query in design
view, and there is a Query Type icon on the toolbar that allows you to
change it.
 
Back
Top