Forms, Tables & Combo Box

[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?

 

[Larry Daugherty]

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-
--

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?