Originally Posted by
TheSpecialist
I have a database where I have one column with 3 digits in it and another column with 4 digits. This database also pulls 2 days before and 3 days after. However, I want to know how can I add on to this sql statement that if I put in 3 digits like 123 that it will pull all the times 123 came and it will also pull numbers like this for my 4 digit columns. I understand that my 4 digit column might pull something like 123...4..5 and so on but I want to know is this possible
Ex. If I enter in my parameter 123 it will show me all the time 123 came and the numbers that came 2 days before and 3 days after and then for my 4 digit column it pulls also 123...(and whatever the number after the 3 digit number )
This is my SQL statement so far
SELECT Erikabase.DTE, Erikabase.Cash3mid, Erikabase.Cash3eve, Erikabase.3nite, Erikabase.4mid, Erikabase.4eve, Erikabase.4nite
FROM Erikabase, qselLotDates
WHERE (((Erikabase.DTE) Between [TargetDates]-2 And [TargetDates]+3))
ORDER BY Erikabase.DTE DESC;
Thank you in advance