Help with blank records

[mfrisbyuk]

Hi All

I have a project where my company needs to record 250+ Username and Passwords
for each team.

I am trying to set up a report to show me only blank fields in the username
or password fields.

In the query i ask which teamleader do you want it gives me every member of
their team great...

But it gives me every record which i don't want

so in the username criteria i added Is Null and did nothing in the Password
field it only showed me the blank records for the username great on the right
track ...

But....

if i also add in the Password criteria Is Null on the next line down, it then
shows me every team which i Don't want i can't seem to only show me the team
that i have asked for.

Look forward to hearing from some soon

Mark J Frisby

 

[Rick B]

If you put criteria on the same row in the query builder, that creates an
"AND" condition. Place the "Is Null" criteria for User Name on one row,
then place the criteria for password on the next row. That creates an "OR"
condition and will locate records where either condition is true.

(I think you will have to place the teamleader criteria on both lines.)

In English...

select all records where TeamLeader=[Enter Team Leader] AND UserName Is Null
*OR* TeamLeader=[Enter Team Leader] AND Password Is Null

 

[mfrisbyuk via AccessMonster.com]

Thank you Rick B

It was that simple just add the teamleader on both line LOL

Mark

If you put criteria on the same row in the query builder, that creates an
"AND" condition. Place the "Is Null" criteria for User Name on one row,
then place the criteria for password on the next row. That creates an "OR"
condition and will locate records where either condition is true.

(I think you will have to place the teamleader criteria on both lines.)

In English...

select all records where TeamLeader=[Enter Team Leader] AND UserName Is Null
*OR* TeamLeader=[Enter Team Leader] AND Password Is Null

Hi All

[quoted text clipped - 29 lines]

Mark J Frisby

 

[John Spencer]

You need to include the team leader criteria on both lines. So that your
criteria is set up something like the following

Field: TeamLeader
Criteria (1): "Fred"
Criteria (2): "Fred"

Field: UserName
Criteria (1): Is Null
Criteria (2): <<Leave blank>>

Field: Password
Criteria (1): <<Leave blank>>
Criteria (2): Is Null

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..