How do I enter many queries at once in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with thousands of records and i would like to put in a
value from column 1 and the return would be from columns 2 and 3 - sometimes
I might want to enter 30 entries from column 1 and other times maybe just 1 !
Can anyone help please?
I am using ACCESS 2003
Liz
 
Liz:

Please do not post the same question multiple times in multiple groups. It
means that you will end up with two or more people answering he same
question.
 
I have a database with thousands of records and i would like to put in a
value from column 1 and the return would be from columns 2 and 3 - sometimes
I might want to enter 30 entries from column 1 and other times maybe just 1 !
Can anyone help please?
I am using ACCESS 2003
Liz
Click to expand...

One way is to use the In() clause. On the criteria line under field 1
put

IN(1, 2, 3, 5, 8, 13, 21, 34, 55, 89)


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top