beginner123
Registered User.
- Local time
- Today, 15:43
- Joined
- Apr 13, 2013
- Messages
- 44
Hi,
Please go easy on me!
I have a query:
SELECT Calibration.KKS, Calibration.[Calibrated Date], Calibration.Frequency, DateAdd('m',[Frequency],[Calibrated Date]) AS [Next Calibration Due]
FROM Calibration
WHERE (((Calibration.KKS) Like "1*"))
ORDER BY Calibration.KKS;
I would like to do something like:
If option button 1 on form is true then
SELECT Calibration.KKS, Calibration.[Calibrated Date], Calibration.Frequency, DateAdd('m',[Frequency],[Calibrated Date]) AS [Next Calibration Due]
FROM Calibration
WHERE (((Calibration.KKS) Like "1*"))
ORDER BY Calibration.KKS;
Else
If option button 2 on form is true then
SELECT Calibration.KKS, Calibration.[Calibrated Date], Calibration.Frequency, DateAdd('m',[Frequency],[Calibrated Date]) AS [Next Calibration Due]
FROM Calibration
WHERE (((Calibration.KKS) Like "2*"))
ORDER BY Calibration.KKS;
Is this possible?
[forms]![Calibration Query]![Line1]
At present I have 4 queries running from different buttons
just having different like values, 0,1,2,3
Regards
Robin
Please go easy on me!
I have a query:
SELECT Calibration.KKS, Calibration.[Calibrated Date], Calibration.Frequency, DateAdd('m',[Frequency],[Calibrated Date]) AS [Next Calibration Due]
FROM Calibration
WHERE (((Calibration.KKS) Like "1*"))
ORDER BY Calibration.KKS;
I would like to do something like:
If option button 1 on form is true then
SELECT Calibration.KKS, Calibration.[Calibrated Date], Calibration.Frequency, DateAdd('m',[Frequency],[Calibrated Date]) AS [Next Calibration Due]
FROM Calibration
WHERE (((Calibration.KKS) Like "1*"))
ORDER BY Calibration.KKS;
Else
If option button 2 on form is true then
SELECT Calibration.KKS, Calibration.[Calibrated Date], Calibration.Frequency, DateAdd('m',[Frequency],[Calibrated Date]) AS [Next Calibration Due]
FROM Calibration
WHERE (((Calibration.KKS) Like "2*"))
ORDER BY Calibration.KKS;
Is this possible?
[forms]![Calibration Query]![Line1]
At present I have 4 queries running from different buttons
just having different like values, 0,1,2,3
Regards
Robin