SQL code help please

[Bradon]

I want to use a macro that collects data with a range of data entries that range from 8p, 8q, through to 8z.

I have tried the code:

[table1]![Yeargroup]="8p" Or [table1]![Yeargroup]="8q" Or [table1]![Yeargroup]="8r" Or [table1]![Yeargroup]="8s" Or [table1]![Yeargroup]="8w" Or [table1]![Yeargroup]="8x" Or [table1]![Yeargroup]="8y" Or [table1]![Yeargroup]="8z"

This works but with one more entry it is too long for the condition box.

Any suggestions as to how to shorten it?

Thanks

 

[Norie]

What do you mean too long?

You should be able to add another condition but you might not be able to see the whole expression.

By the wat have you tried the Between or In operators, or putting the criteria in seperately?

 

[Bradon]

When I tried to add an extra one it brought up a message box saying it was too long.

What is the syntax for "between" ?

 

[Norie]

Never seen that error message.

Maybe

[table1]![Yeargroup] Between "8p" And "8z"

By the way you don't need to set the criteria in one expression like that.

You can use the rows and columns in the query design view for Or/And. Sorry but I can't remember which is And and which is Or.

 

[Bradon]

Thanks - I learn yet again!