I was wondering if anybody could help me with this problem for access97 SQL
I want this code to inquiry records that are 3 yrs and older, with a year_type of 1. Can somebody help me code this please!!!!!!!!!!!!
Here's what i have so far:
DELETE [ArchBOILER].[Inspection_Date], (DateDiff("d",[Inspection_Date],Now()))/365 AS Differance, Year_Type
FROM [ArchBOILER]
WHERE ( ( ( ( DateDiff ("d", [Inspection_Date], Now() ) ) / 365 )>=3 )are you using DELETE to to inquiry records ?|||yes
Originally posted by Bigced_21
I was wondering if anybody could help me with this problem for access97 SQL
I want this code to inquiry records that are 3 yrs and older, with a year_type of 1. Can somebody help me code this please!!!!!!!!!!!!
Here's what i have so far:
DELETE [ArchBOILER].[Inspection_Date], (DateDiff("d",[Inspection_Date],Now()))/365 AS Differance, Year_Type
FROM [ArchBOILER]
WHERE ( ( ( ( DateDiff ("d", [Inspection_Date], Now() ) ) / 365 )>=3 )
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment