Senin, 26 September 2011

Re: [MS_AccessPros] Query for Missing Data

 

This worked like a charm. Thank you very much. I have a groove in my head over the scratching over this one. :-)
Terryomsn

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> 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@...
> 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]
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar