Access Formula Query Problems

[Legacy 306721]

Here is my code:

Expr: IIf([Table]![Column]<10,"0 - 9",IIf([Table]![Column]<20,"10 - 19",IIf([Table]![Column]<30,"20 - 29",IIf([Table]![Column]<40,"30 - 39",IIf([Table]![Column]<50,"40 - 49",IIf([Table]![Column]<60,"50 - 59",IIf([Table]![Column]<70,"60 - 69",IIf([Table]![Column]<80,"70 - 79",IIf([Table]![Column]<90,"80 - 89",IIf([Table]![Column]<100,"90 - 99",IIf([Table]![Column]<110,"100 - 109","N/A")))))))))))

When I run a Select query on this code, it runs fine - but when I try filtering data, it gives me the error: "Syntax error (missing operator) in query expression 'Expr'."

What is wrong with the code I have?

Thanks.

 

[Legacy 306721]

Problem has been fixed. Apparently Access does not like variable names with spaces in them, so I removed every space in the name I have for Expr.

 

[Darren Bartrup]

You could use

 IIF(Column MOD 10 =0,Column,(Column\10)*10) & " - " & IIF(Column MOD 10 =0,Column+9,(Column\10-(Column MOD 10 <>0))*10-1)

which will work with any positive number.

*	A	B
1	Column	Expr1001
2	3	0 - 9
3	5	0 - 9
4	8	0 - 9
5	21	20 - 29
6	36	30 - 39
7	90	90 - 99
8	85	80 - 89
9	32	30 - 39
10	141	140 - 149
11	150	150 - 159
12	233	230 - 239
13	-5	0 - 9

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:55px;"><col style="width:62px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4