Help with two queries please

[nancybrown]

Query #1:

Three fields: 1) Owner; 2) Reconciler 3) Reviewer.
Need a to filter out any blanks for any or all of these fields

Query #2
One field: FDC Code
Need to filter out numbers "between" 7799 and 7899

Many thanks

 

[Joe4]

Criteria for 1st:

WHERE ((Not [Owner] Is Null) AND (Not ([Reconciler]) Is Null) AND (Not ([Reviewer]) Is Null));

Criteria for 2nd:
If your FDC Code field is numeric:

WHERE [FDC Code] Between 7799 And 7899;

If your FDC Code field is text:

WHERE [FDC Code] Between "7799" And "7899";

 

[nancybrown]

Thank you Joe

quick question ... for the code related to blanks . . . if I use And does that mean all conditions for all three fields need to be blank? Some fields may have some data and some or all may not.

 

[Joe4]

If you look closely, it says that all three values must NOT be empty in order to return that record. That means if any of these fields is empty, it will NOT return that record (which is how I read your question - only return records where are three fields have something in them).

 

[nancybrown]

Many thanks for clarifying.

 

[nancybrown]

Additional Help Please.

Criteria 2 . . . need to see everything that is not between 7799 and 7899. The code I used was: "not between 7799 and 7899" code worked but it did not show results with blank fields. need to see everything except for this range.


Many thanks

 

[boblarson]

Not Between 7799 And 7899 OR Is Null

 

[nancybrown]

Thank you

 

[nancybrown]

Need add'l instruction . . . Three separate fields . . . owner, reconciler, reviewer . . . one report will show any and all blanks in any or all of these three fields . . . second report should not have any blanks. Please be detailed with placement of code . . . been a while since working in Access . . . out of practice.

Thank you

 

[alansidman]

In the criteria for each field in your query, place the term Not Null, but ensure that they are on separate lines so in effect you have an "Or" in your WHERE section of your SQL statement if you were to look at the SQL statement of the query.

Alan