Re: Display field of most recent child record?

Hi!

My apologies for the very naive question but how/what is the syntax to get the maximum record ID#?
 I created a field and typed ' Max([CI-PN ID#]) ' under the formula field but the syntax seems to be incorrect.
 How do I get a max of a record?
And more generally how can I get the max of a table or a column of a table?

Thanks for your help