Help me please with SQL!!!!!!!!!!!!!!!!

Bigced_21 · #1 (**permalink**) 12-03-02, 14:19

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 )

fhunth · #2 (**permalink**) 12-03-02, 14:38

are you using DELETE to to inquiry records ?

Bigced_21 · #3 (**permalink**) 12-03-02, 14:41

yes

Quote:

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 )

Internet Services

Web Development

Digital Marketing

Consumer Tech