Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56

    Red face Unanswered: Help me please with SQL!!!!!!!!!!!!!!!!

    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 )

  2. #2
    Join Date
    Oct 2002
    Location
    Argentina
    Posts
    72

    Re: Help me please with SQL!!!!!!!!!!!!!!!!

    are you using DELETE to to inquiry records ?

  3. #3
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56

    Re: Help me please with SQL!!!!!!!!!!!!!!!!

    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 )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •