Calculated Query!

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

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
 
-----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
Click to expand...
enter the data into another form which is based on a
select query
 
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
Click to expand...

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).
 
Back
Top