How do I create a list? Access 2007

[shabbaranks]

Hi,

Just fumbling my way around Access 2007, is the only way you can create a drop down list of number by creating a table and inserting a combo box?

Im trying to create a list of hours for example:
0.5
1
1.5
2

Etc... Thanks!

[alansidman]

An alternative is to do it all in SQL

http://www.w3schools.com/sql/sql_create_table.asp

and

http://www.w3schools.com/sql/sql_insert.asp

but I am not sure this is any quicker than doing it manually.

If you have a long list of numbers, you may want to create the table in Excel using formula such as A1+0.5 and then copy it down. Now import the table into Access.



Alan