Using a query in a second one

S

Stefan

Hi,

I have a query that uses a table to calculate some numbers.
If I create a form, based on the table with the numbers and a link to the
calculation-query, I can't change the data, although I do the changing in the
table, not in the query.

What's wrong??

Stefan
 
T

Tom Wickerath

I'm not sure what you are describing....
If you are trying to change the value displayed in the calculated field, you
cannot do this.

Are you saying that you created a query, which includes one or more
calculated fields, but you find that a form based on that query is read only?
If so, can you edit records using the query? Does your table include a
primary key? Is the primary key included in the query?

Tom
_____________________________________

:

Hi,

I have a query that uses a table to calculate some numbers.
If I create a form, based on the table with the numbers and a link to the
calculation-query, I can't change the data, although I do the changing in the
table, not in the query.

What's wrong??

Stefan
 
S

Stefan

Tom,

If I remove the calculating query, the remaining fields can be changed. As
soon as I put the query back, the same field's can't bz changed. So, it has
to be something in the query.
 
J

John Vinson

Tom,

If I remove the calculating query, the remaining fields can be changed. As
soon as I put the query back, the same field's can't bz changed. So, it has
to be something in the query.
Click to expand...

No Totals query, nor any query containing a Totals query, is ever
updateable.

You may want to either use a subform based on the totals query to
display the calculated values, or use DSum() or DCount() or one of the
other domain functions to do the calculation.

John W. Vinson[MVP]
 
Top