I have an access database with the following columns.
"product 1","product 2","product 3", "product 4","focus 1","focus 2","focus 3" and "focus 4"
I'm trying to create a report that separates these products depending one their focus fields (e.g. if field is not empty display products on top...