Query code

[ladybug via AccessMonster.com]

I need a code in a query that works like:
Between [Enter First Program]And[Enter Second Program]

However, when I use this it shows me the first program, second program and
all programs between the two.
I want to just see the data from the first program and the second program.
When I take out between, no data is returned.

ladybug

 

[David F Cox]

one way:

IN ([Enter First Program],[Enter Second Program])