PC Review


Reply
Thread Tools Rate Thread

Combining queries that don't match

 
 
New Member
Join Date: Jul 2011
Posts: 1
 
      20th Jul 2011
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..
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
combining queries =?Utf-8?B?d2VzIGs=?= Microsoft Access 1 12th Jun 2007 09:56 PM
Combining queries =?Utf-8?B?UGhpbA==?= Microsoft Access Queries 5 26th Jan 2007 12:53 PM
Help Combining Two Queries... Sean Massey Microsoft Access Queries 5 20th Dec 2006 05:26 PM
Another MATCH of combining with two MATCH functions? AA Arens Microsoft Excel Discussion 1 3rd Dec 2006 09:26 PM
Combining queries =?Utf-8?B?U3RlcGhhbmll?= Microsoft Access Queries 1 18th Nov 2005 08:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:39 PM.