Full Version: Value greatest or smallest
UtterAccess Forums > Microsoft® Access > Access Forms
144Tsgt
What should be simple I made hard. I have a form pulling directly from a table. I want to pull the greatest value from separate columns and only show that value. Should I use a text box or some other method to get the best results.
Edited by: 144Tsgt on Thu Aug 16 0:17:24 EDT 2007.
strive4peace
With all due respect, it sounds like you should restructure your data ... if you have multiple fields storing the same information, the fields need to be multiple records in a related table. Read this:
ccess Basics
http://www.utteraccess.com/forums/showflat...;Number=1220772
30-page Word document on Access Basics (for Programming) -- it doesn't cover VBA, but prepares you for it because it covers essentials in Access
144Tsgt
I have table with 5 separate columns each have different values in them. I want to create a form that can pull the greatest values from each of these columns
Larry Larsen
Hi
I have to agree with Crystal.. with regards to your data structure..
Are you able to show us your table structure..?
thumbup.gif
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.