Help WHERE

[Elliot]

NEW TO ACCESS
i have criteria in field A "3 or 4"
I need to put in a statement which says when the the
actual date is NOT NULL for both 3 and 4 then show the
records.

I dont' want to show records when only one of them is NOT
NULL!

CAn anyone help ASAP please??

 

[Jeff Boyce]

Elliot

I'm confused between criteria of "3 or 4" and "actual date". Are you
describing two separate fields? Could you spell out the logic of what you
are trying to do?

Example:

Field A ActualDate Result
"3" Null don't
"4" Null don't
"3" not Null do
"4" not Null do

How could Field A be both "3 and 4"? (storing more than one value in a
field runs counter to good design principles).

 

[Guest]

Sorry!
The field in the table shows deliverable id's where 3 =
financial statement and 4 = report amongst others.
actual date is the date the deliverable was received. in a
different table.
if the field is null (ie.no date) then the deliverable
hasnt' been received.
i want the query to show ONLY where BOTH have been
received.

does that make more sense

where deliverable id is 3 and actual date is not null AND
where deliverable id is 4 and actual date is not null