Find Highest Number within Data

[dvent]

Hi All,

Can anyone tell me how to find the Max number in a row if my data looks like this:


Name 1.....1.....2.....3.....4
Name 2.....1.....0.....0.....0
Name 3.....1.....2.....0.....0

Name 1 would be 4
Name 2 would be 1
Name 3 would be 2

I would like this number displayed in the last column of query.

Thanks

 

[Rich]

Look up the Max function witin a Totals query

 

[HAMMAMABUARQOUB]

You mean the CrossTab query

 

[neileg]

Looks like your data is not normalised. This would lead you to having four records to compare not four columns. That would make the task extremely simple. Research normalis(z)ation in these forums, or start with Wikipedia.