Results 1 to 5 of 5
  1. #1
    maxx3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Mosta Malta
    Posts
    32

    Medium date permits

    Hi friends I am inputing data and today I came across a problem with dates.The problem is I have a Volume start date and a Volume end date and I've been inputing date for quite a while now but today I tried to input 2 Mar 1960 in the start date and 31 Apr 1960 in the end date and here is where I have the problem because when I enter 31 it is not execpting it, it says "you may have entered text in a numeric field or a number that is larger than than the field size setting permits my date is set to medium Date is there away to set the date to take the 31 Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    There are only 30 days in April! 31 Apr 1960 is not a valid date.

  3. #3
    maxx3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Mosta Malta
    Posts
    32
    yep thanks I didn't think of that thanks when inputing data you go blank you'll became a robot

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. Been there, done that. Are we ready for the Solved thread tool?

  5. #5
    maxx3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Mosta Malta
    Posts
    32
    yes I do that

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Top Date per Date in another table
    By danneedham in forum Queries
    Replies: 1
    Last Post: 05-28-2008, 05:47 PM
  2. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM
  3. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums