User Profile

Collapse

Profile Sidebar

Collapse
hempknight
hempknight
Last Activity: Aug 17 '07, 04:38 AM
Joined: Aug 3 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hempknight
    replied to about searching Dates within a range using quries or SQL
    in Access
    Sorry to be such a pain in the bum Rabbit..

    but i did as you said and even when i puposely modified a comp to expire on the 1/9/07

    the query didnt show anything

    here's the code in SQL format since i cant screendump from the school's comp for some reason.. man i really should have gone back and re-do all my access course this is making me feel so stupid right now..~_~

    Code:
    SELECT ComputerDatabase.[Primary
    ...
    See more | Go to post

      Leave a comment:

    • hempknight
      replied to about searching Dates within a range using quries or SQL
      in Access
      oops! forgot to ask..Rabbit umm does the text in line 1 for the data validation rule (like how only NA or a date can be entered) or is it part of the text i should chuck into my Warrenty End Date query??

      sorry i know i said i'd chuck it in and see if it works..but i only got a chance to access the school's Dbase just today and i've been flat out prepping for Uni Exams..so i forgot where i was meant to place it..
      See more | Go to post

        Leave a comment:

      • hempknight
        replied to about searching Dates within a range using quries or SQL
        in Access
        thanks for that Rabbit!

        i'll chuck that in and give it a try..

        BTW: iif ?? is that meant to have 2 i's? or that a typo?...
        See more | Go to post

          Leave a comment:

        • hempknight
          started a topic about searching Dates within a range using quries or SQL
          in Access

          about searching Dates within a range using quries or SQL

          Hi! all

          this is probably been answered in part elsewhere but does anyone know how to get Dates that are 30 days from the current date on the system?

          my Database has a field to hold the Warranty End Date for a computer system.

          the user can either Enter "N/A" or a Date in this format dd/mm/yy anything else and it should popup a msgbox indicating a problem.

          to allow the use of N/A...
          See more | Go to post
          No activity results to display
          Show More
          Working...