Max? DMax? Just give me the higher value

[Dale Fye]

Colby, I strongly encourage you to "NOT" add another field
to your table. You can always compute the greater of
these two values in a query when you need it.

MaxOfXandY: IIF([X]>= [Y], [X], [Y])

HTH
Dale

-----Original Message-----
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.
.