General discussion

Locked

Getting Access to Provide High and Low N

By jgreer ·
I am working on a scoring database for a sales event and need assistance on it, I am using Access 97. On a specific entry I need it to automatically show on the form the lowest and highest score entered under a specific entry. How do I get Access tocomplete this task?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Getting Access to Provide High and Low N

by eSadacca In reply to Getting Access to Provide ...

Look into the "DMax" and "DMin" built-in functions.

Collapse -

Getting Access to Provide High and Low N

by jgreer In reply to Getting Access to Provide ...

Poster rated this answer

Collapse -

Getting Access to Provide High and Low N

by donq In reply to Getting Access to Provide ...

You might want to display your Min and Max values in a Form Footer text field where you could also enter the expression:

=" Minimum to date: " & Min([FieldName]) & " and Maximum to date: " & Max([FieldName])

Look into the "DMax" and "DMin" built-in functions is also a good suggestion.

Collapse -

Getting Access to Provide High and Low N

by jgreer In reply to Getting Access to Provide ...

Poster rated this answer

Collapse -

Getting Access to Provide High and Low N

by jgreer In reply to Getting Access to Provide ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums