Max? DMax? Just give me the higher value

From: Colby (Colby_at_discussions.microsoft.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 09:35:03 -0700

I have two score fields and I am wanting to create a new score field that only shows the greater of the two. I tried to use the Max function but it keeps saying not enough arguements. I need it to compare on a record level.

Can someone please save my sanity?

[x]=200
[y]=150
[z] new field that would compare [x] and [y] and return the higher [x] in this case.
If both fields are equal to zero I need it to show 0.