Using a query in a second one

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[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.

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]