I was wondering if there is a way to somehow get a combo box on an access form to do something like the following
iif([BatchCheck]=True,SELECT [CatalogueNumberStockBatch_Transfer_to_WIP].[SumOfStockQty] FROM CatalogueNumberStockBatch_Transfer_to_WIP;,SELECT [CatalogueNumberStock_Transfer_to_WIP].[SumOfStockQty] FROM CatalogueNumberStock_Transfer_to_WIP;)
Is this possible, I would love to use just one query to do this but I cannot get it to work if there is a null batch field (ie the query won't return anything)
I hope this is enough info..