RE: [MS_AccessPros] Query for Missing Data

Just a WAG
Baby Steps: You might want to create a query that groups by the first three characters of Block. Create a query or table with just the 88, 89, and 90 values. Combine these in a cartesian query (no joins) to get every possible combination of block and run. Create a new, unmatched query with this cartesian query and your table.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: terryomsn@msn.com
Date: Fri, 23 Sep 2011 18:06:13 +0000
Subject: [MS_AccessPros] Query for Missing Data

How can I construct a query(ies) that will tell me if each Block in BlockRun below doesn't contain Run data for runs 88, 89, and 90?
Block (Left [BlockRun], 3) contains Run (Right [BlockRun],2]
BlockRun data example
99801
99888
99889
Missing 99890
99901
Missing 99988
99989
99990
Thanks,
Terryomsn

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/