- Joined
- Jul 20, 2011
- Messages
- 1
- Reaction score
- 0
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.
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: