Hello: i am an absolute Access beginner. I understand BASIC queries. I want to create a query that compares 7 different fields for the lowest value. The fieldname containing the lowest value should be displayed in the results. Here's an example:
Field A Field B Field C Field D
22 10 15 35
The query should display a column that shows some identifier such as "B" for the above record (which contains the lowest value). As simple as possible would be great - please assume that I do *not* know much at all.... Thank you!!!