I need three seperate query condition statements which are similar but slightly different and I am not sure
of the correct syntax for these...
the first condition is as follows:
In a query the field ItemType is a default value of "I" unless the value of StockType = "B" in which case
ItemType = "F"
The second condition is as follows:
In another query the field Commit is a default value of "_" unless the value of SN = "3" or "7" in which case
Commit = "1".
The third condition is as follows:
In a third query, the field Typ is a default value of "_" unless Scode = Yes then Typ = 7 or if Lot = Yes
then Typ = "3"
thanks
of the correct syntax for these...
the first condition is as follows:
In a query the field ItemType is a default value of "I" unless the value of StockType = "B" in which case
ItemType = "F"
The second condition is as follows:
In another query the field Commit is a default value of "_" unless the value of SN = "3" or "7" in which case
Commit = "1".
The third condition is as follows:
In a third query, the field Typ is a default value of "_" unless Scode = Yes then Typ = 7 or if Lot = Yes
then Typ = "3"
thanks