Hello everyone.
I am having a recurring problem when developing my database and was wondering if there was a standard workaround.
I have for example a query that i need to display in Datasheet View. Ideally as part of the query i would have one of the fields come from another query that has a sum function. That all works as it should, apart from the fact that as soon as the field that comes from the Sum function in the other query is displayed in the form Datasheet View, the records become not editable. Of course i do not want to be able to edit the summed field, but only the other fields in that query entry.
It is important for me for the data to be able to be edited directly from the Datasheet View. Unfortunately in order to be able to edit i have to forego seeing the summed field, which is not critical for me, but would be really nice if i didn't have to.
So, would anyone know of a workaround to this problem? Some special way to get the required summed data into my query output without making it not editeable?
I am thinking to go down the route of adding a new "Sum" field to one of the original tables, running an update query with the Sum value into that field, that using that in my desired query...
Any suggesting would be much appreciated
I am having a recurring problem when developing my database and was wondering if there was a standard workaround.
I have for example a query that i need to display in Datasheet View. Ideally as part of the query i would have one of the fields come from another query that has a sum function. That all works as it should, apart from the fact that as soon as the field that comes from the Sum function in the other query is displayed in the form Datasheet View, the records become not editable. Of course i do not want to be able to edit the summed field, but only the other fields in that query entry.
It is important for me for the data to be able to be edited directly from the Datasheet View. Unfortunately in order to be able to edit i have to forego seeing the summed field, which is not critical for me, but would be really nice if i didn't have to.
So, would anyone know of a workaround to this problem? Some special way to get the required summed data into my query output without making it not editeable?
I am thinking to go down the route of adding a new "Sum" field to one of the original tables, running an update query with the Sum value into that field, that using that in my desired query...
Any suggesting would be much appreciated