Expand|Select|Wrap|Line Numbers
- SELECT WaltLottery.DTE AS TargetDates, WaltLottery.Cash3eve, WaltLottery.Cash3nite
- FROM WaltLottery
- WHERE (((WaltLottery.Cash3mid)=InStr([Enter###s: Separated by Commas],[Cash3mid])));
but when I run the near identical script:
Expand|Select|Wrap|Line Numbers
- SELECT WaltLottery.DTE AS TargetDates, WaltLottery.Cash3eve, WaltLottery.Cash3nite
- FROM WaltLottery
- WHERE (((WaltLottery.Cash3mid)=[3###;])) OR (((WaltLottery.Cash3eve)=[3###;])) OR (((WaltLottery.Cash3nite)=[3###;]));
Is there something that I am missing in the Instr function, (I have never used the Instr function. Need help please!