Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Forms, Tables & Combo Box

Discussion in 'Information Technology' started by Craig, Jul 28, 2006.

  1. Craig

    Craig
    Expand Collapse
    Guest

    I'm trying t create a simple database to track expenses.

    I creased a table with fields than include Year, Month. I would like to
    have each field as a a drop down box.

    1 -Do I need to create seperate tables each with the various year and month
    attributes?
    2 - How do I make sure the Month does not sort by alphabetical order?
     
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee to Represent US Sikhs Breaking News Sep 13, 2013
    India Poll reforms on crash course Breaking News Sep 7, 2013
    General A Conversation about the Grammatical Forms of Raam and Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 bn Aid for Africa, Seeks Support for UN Reforms Breaking News May 24, 2011

  3. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    Use a single field to hold the date, don't name it "Date" as that's a
    reserved word. Store the date in it. In queries you can then use
    that field to put things in date order and to extract things on or
    before or after dates and even Between two dates. Look in Access Help
    for things to do with dates, it's a lot. Another thing to learn is
    Format(). There are some date specific formats that are really
    useful.

    Welcome to the world of Access. Some other useful newsgroups to lurk
    are

    microsoft.public.access.gettingstarted
    microsoft.public.access.tablesdesign

    A very useful site is www.mvps.org/access

    HTH
    --
    -Larry-
    --

    "Craig" <Craig@discussions.microsoft.com> wrote in message
    news:CE62C531-38D2-40BE-B287-717B0417AB3C@microsoft.com...
    > I'm trying t create a simple database to track expenses.
    >
    > I creased a table with fields than include Year, Month. I would

    like to
    > have each field as a a drop down box.
    >
    > 1 -Do I need to create seperate tables each with the various year

    and month
    > attributes?
    > 2 - How do I make sure the Month does not sort by alphabetical

    order?
     

Share This Page