Calculated Query!

[Floyd Forbes]

I have a Form base on a calculated query. The query is base on a table.
How can I input data in table from a control on the form. Every time
I tried type data nothing happened.

Floyd

 

[Alan]

-----Original Message-----
I have a Form base on a calculated query. The query is base on a table.
How can I input data in table from a control on the form. Every time
I tried type data nothing happened.

Floyd


.
Calculated queries are not updateable. you would have to

enter the data into another form which is based on a
select query

 

[John Vinson]

I have a Form base on a calculated query. The query is base on a table.
How can I input data in table from a control on the form. Every time
I tried type data nothing happened.

Floyd

Please post the SQL view of the query. "Calculated query" is
ambiguous!

If it's a Totals query then you cannot do this: since each "record" of
a totals query is potentially a sum or collation of multiple records,
no such query is ever updateable. If it's a simple Select query with
some calculated fields, you should be able to update the table fields
(though not, of course, the calculated fields).