Hi,

Yup, the query won't let me enter data in the other fields.......am I using
the wrong type of query. It is a select query.

Thanks

Kenny

"Van T. Dinh" wrote in message
...
Do you meant you can't enter data in the Calculated Field or other Fields?

You cannot enter data in Calculated Field and you should not store the
Calculated Value in the Table since this violated the Relational Database
Design Principles.

--
HTH
Van T. Dinh
MVP (Access)



Kenny wrote in message ...
Hi there,

Ok......I tried it and it now displays the correct result, except now I
can't enter data, as the original record source was my table.

Kenny