max & Int together

[mike wild]

I need to use the Int and max functions together.

To find the largest number and then crop to the whole number.

Can It Be Done

I am working in the control source property of the field.

Here is what i have so far:

=The Leader has £" & Max([total1]) & " In the Bank"

 

[dcx693]

The first problem you'll encounter is that there is no built-in Max() function. There is an aggregate Max() function that you can use when running totals queries, and a DMax() function. There should be no issue using Int() with either of those.

 

[mike wild]

How?

How do i use them together:

int & Max([total1])?