Help With Expression

[Johnthelleader]

I have got the following code as an expression for a report:

=Int(([Amount])/50000)*50000 & " - " & Int((([Amount])/50000)+1)*50000

How do I get it to pick figures greater than 50,000 and then figures greater than 100,000 plus?

 

[Dennisk]

not quite sure what you are trying to achieve as you are creating a string.

 

[Johnthelleader]

I am trying to produce a report so that it groups figures greater than 50,000 and then over 100,000.

 

[John_W]

Well assuming your report is based on a query, you could add a field to your query to indicate into which of these categories the record falls - then group by that field.