Mulit Function Query
in [General]
|
From: LewisDUA on 6 Apr 2010 12:56 I am working on this query. I want to run it, so it will show what my users are missing in their files. But only what they are missing. What would the criteria be in order to do that?
From: John W. Vinson on 6 Apr 2010 13:35 On Tue, 6 Apr 2010 09:56:21 -0700, LewisDUA <LewisDUA(a)discussions.microsoft.com> wrote: >I am working on this query. I want to run it, so it will show what my users >are missing in their files. But only what they are missing. What would the >criteria be in order to do that? You'll have to give us some more explanation. I know that one thing that's missing from my files is a stock certificate for 20,000 shares of Microsoft, and I'm pretty sure there's also no title deed to the Brooklyn Bridge... What's in their files, how are the tables structured, and how can a "missing" record be identified? -- John W. Vinson [MVP]
From: Richard on 6 Apr 2010 13:47 Under the field you want to show the "missing" data, in the criteria cell type Is Null. Richard "LewisDUA" wrote: > I am working on this query. I want to run it, so it will show what my users > are missing in their files. But only what they are missing. What would the > criteria be in order to do that? >
From: LewisDUA on 6 Apr 2010 13:58 That would work for one piece of data. But, i have muilt data pieces. I have Name, then lets say we also have Doc1, Doc2, and Doc3. John is missing all three. Tim is missing Doc2. Do you get what i'm saying? And thanks. "Richard" wrote: > Under the field you want to show the "missing" data, in the criteria cell > type Is Null. > > Richard > > > > "LewisDUA" wrote: > > > I am working on this query. I want to run it, so it will show what my users > > are missing in their files. But only what they are missing. What would the > > criteria be in order to do that? > >
From: Steve on 6 Apr 2010 14:01
Yiu can only do this for one field. If you set the criteria as Null for two or more fields, the data must be "missing" for ALL the fields you set the criteria as Null to be returned by the query. Steve santus(a)penn.com "Richard" <Richard(a)discussions.microsoft.com> wrote in message news:AA11B9C8-4C54-40A6-9CD3-ADB5CE5CB052(a)microsoft.com... > Under the field you want to show the "missing" data, in the criteria cell > type Is Null. > > Richard > > > > "LewisDUA" wrote: > >> I am working on this query. I want to run it, so it will show what my >> users >> are missing in their files. But only what they are missing. What would >> the >> criteria be in order to do that? >> |