I have 8 different queries that I need to merge into one query or report. Each query represents a task evaulation. each query has only 2 fields, one is a personal identifier (initials) and the other is a value.
The personal identifier field isn't identical for every query.
What I want in the end is for the first column to contain all of the initials from all 8 queries and the subsequent columns to contain the coresponding value. Where there is no value I want a zero.
Last edited by elderwilson; 20th Jul 2011 at 10:21 PM..
|