I have a table with the following fields:
ID (pk auto-generated)
I need a query with these conditions:
1) shows all fields,
2) only displays where ELEMENT = 'Fe'
3) sets RESULT = (0.5 * RESULT) if QUALIFY = "U"
4) GROUPS BY LOCCODE, LOCATION, MYDATE (only unique LOCCODE-LOCATION-MYDATE are displayed)
This is part 1 of a 3 part question.