hi all - what would the criteria expression be to do the following - line (or column) of nine single digit number cells, that may either be null or have a value between 1 and 9. I have two queries that return correct results for each cell - each of the 81 cells has its own grid reference (from a1 to i9), by the way, and the 9 columns are numbered 1 to 9, the nine rows are a to i. So, i am creating an append query to add separately the results of each of the above two queries to a table called “possvals”. My problem is in working out an appropriate expression that gives only the possible values for each cell in (say) line a that is “null” and that follows the sudoku rule- ie no value can appear twice in any one row or column. I thought maybe the expression would be something such as -
= >0 and <10 and/but not equal to “the not null values found in the ‘line a’ query” —- to put it in layman’s language ...
As you can see, I am struggling due to miniscule access experience but hopefully this makes some sense as to what I’m getting at.
can you suggest some code that would work? Ed