Good afternoon! I think this is a relatively simple thing to do, but I do now know how! I am using MS Access 2007
Here is a sample of my data table. Top row is column headings. This is a multi-row table. Columns seperated by -
Product - Week - column 1 value - column 2 value
LEGS - WK1 - 20 - 40
DRUMS - WK4 - 60 - 0
I need to have the query return the following:
LEGS - WK1 - 40
DRUMS - WK4 - 60
I need SQL code or another way of bringing back the max value of column 1 value and column 2 value in my query results.
Bookmarks