T
terryljsmith
how do i run a query to select one item with many categories?
ie,
name | cat1 | cat2 | cat3 | cat4 |
tom | hat | gloves | tie | watch |
doug | shoes | shirt | | hat |
and i would like the query results to look like this -
name | cat? |
tom | hat |
| gloves|
| tie |
doug | shoes |
| shirt |
| hat |
so that if one field is blank (cat3 for doug) it will roll up to the
next line........
possible?
ie,
name | cat1 | cat2 | cat3 | cat4 |
tom | hat | gloves | tie | watch |
doug | shoes | shirt | | hat |
and i would like the query results to look like this -
name | cat? |
tom | hat |
| gloves|
| tie |
doug | shoes |
| shirt |
| hat |
so that if one field is blank (cat3 for doug) it will roll up to the
next line........
possible?