I have 2 databases. One database has scores for 800 people. I have a summary field which averages the scores for different groups. I have to know how to round the numbers in a summary field to get a result from the second data base.

My other data base has groups of numbers. For example if a group would get a 275 the raltionship with the other database should return 91. I have all the numbers in the second database, but they are all whole numbers. My first database always returns an average score with a decimal.

so when I get an average from database 1 of 275.51 it will not return the desired 91.

Do I set another field to round the average before the summary?

Any ideas???

Thanks

Lester

Ok, here is what you do.

1st in your number format it as of course a number and then click decimal and make it 0 (Zero)

If that doesn't work your can try either the Truncate function or the Round function. I prefer the Truncate. Formatting the number should work though.