So, I have 3 queries and two tables in this database, as follows

Table 1, which has a unique identifier and 11 fields, including several booleans and a date

Table 2, which has 5 percentage values used in calculations.

Query 1


Table 1 ID
Table 1 field 1
Table 1 date field
table 2 percentage 1
calculated field from percentage 1 and a field in table 1
table 1 boolean 1
table 1 boolean 2

Queries two and three are variations on the above.

My problem is I need the booleans to be usable in the query datasheet view, but as soon as I add the calculated field, this isn't possible.

How can I have both a calulated field and a usable boolean in one query datasheet view? Is this possible? If not, are there any workarounds?

What are you trying to do with your check box? Can you post a sample to look at?

David

Thanks for the reply

What I (or, I should say, my boss) wants to do is bring up this query, and be able to quickly toggle the two booleons at the end from this.

So in theory is that you want to show the results of a query then have the facility to toggle the check boxes to dynamically refresh the query. Is this correct?

If so, what you really need to do is to display the results of the query in a listbox and have check boxes on a form that when clicked refreshes the contents of the listbox with the relevant data from the underlying query.

If he want to actually change the boolean value in the table and the query will not let you then it is most likely that the query has been constructd in such a way that is has become a non-updateable query.

David