finding highest value

[rickmac1234]

hello

how can i return the highest value from a specific field accros the entire database

[Vaughan]

Max( fieldname )

[Genx]

wont this only work through a relationship vaughan? i.e. max ( table::field ) where table is a related TO and field the field in the related to... though you could just use a self join between two TO's that always evaluated to true..

correct me if im wrong

~genx