Easy Query Problem

[tomc112]

Access 97

Change_Control_Number Issuance_Date
CC040594
CC040594 11/10/04
CC040594 11/15/04
Not Complete

Change_Control_Number Issuance_Date
CC040594 11/09/04
CC040594 11/10/04
CC040594 11/15/04
Complete
I want to show the completed in a query It is not complete if there is
a blank. I know this is simple but I've hit a mental block and can't
solve.

[Rick Brandt]

to*****@bellsouth.net wrote:

Access 97

Change_Control_Number Issuance_Date
CC040594
CC040594 11/10/04
CC040594 11/15/04
Not Complete

Change_Control_Number Issuance_Date
CC040594 11/09/04
CC040594 11/10/04
CC040594 11/15/04
Complete
I want to show the completed in a query It is not complete if there is
a blank. I know this is simple but I've hit a mental block and can't
solve.

It's not simple and it's something that you would not normally do with a
query. All of the output rows from a query each represent the same thing.
It is not appropriate to attempt ot put a "summation" at the bottom of the
query. Such things belong on a form or report.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Ed Robichaud]

If I understand you, you want to display/count records that either
"complete" or "not complete" and the difference between them is whether the
[Issuance_Date] has a date value or is null/blank. Create a query that has
at least those two fields, and set the criteria in the [Issuance_Date]
column to "Is Null" to show completed or "<>Null" to show not completed.
-Ed

<to*****@bellsouth.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Access 97

Change_Control_Number Issuance_Date
CC040594
CC040594 11/10/04
CC040594 11/15/04
Not Complete

Change_Control_Number Issuance_Date
CC040594 11/09/04
CC040594 11/10/04
CC040594 11/15/04
Complete
I want to show the completed in a query It is not complete if there is
a blank. I know this is simple but I've hit a mental block and can't
solve.