Sum Queries and Storing Calculated Fields

[jsanders]

Hello All,

Probably trying to do the impossible.

Normally I would never (that’s a long time) have the results of a calculated field in a table, but I’m stumped.

Table1
TestID: Autonumber
Quantity: Number
Selected: Yes/No

Table2
SumID: Autonumber
TestID: Number, Foreign Key
Quantity Delivered: Number

Query1-Sum Query
Table2
TestID: Group
Quantity Delivered: Sum

Query2- Select Query
Record Sets

Query1 Table1
TestID-----------------------------------TestID
Quantity Deliverd Quantity
Select

Fields in Query2
TestID from Table1
Select from Table 1

Run Query
Can’t update “Select” field


So I’m thinking that I should create a 3rd query to update the summed Quantity Delivered into a new field in table 1. Which would in effect create a stored calculated field.

 

[jsanders]

Well I guess I'll run a "Make Table" Query then update the sum field with it.
The main thing will be to keep user from having access to that field.

 

[mresann]

"Select" is one of those words you should never use as a field. Generally, any word that is identical to an action or function in Access should not be used, such as Select, From, Now, etc.

Change it to "Select_1" or something similar and see what happens.