help..

[ladyville]

Hi all,

I am new in using acces...
I am doing a database for daily log records..
In Inquiry query i have:
1.name
2.phone number
3.fax number
4. status (closed,follow-up reqired)

On my find record form,what will I do to get all the records un specified
status..
like when i choose "closed" status, I would like to see all the records under
that status...

Thanks in advance!
ladyville

 

[bhicks11 via AccessMonster.com]

If you are using a query, in the criteria for status put "closed" or "follow-
up" etc.

Bonnie
http://www.dataplus-svc.com

 

[John W. Vinson]

Hi all,

I am new in using acces...
I am doing a database for daily log records..
In Inquiry query i have:
1.name
2.phone number
3.fax number
4. status (closed,follow-up reqired)

On my find record form,what will I do to get all the records un specified
status..
like when i choose "closed" status, I would like to see all the records under
that status...

Thanks in advance!
ladyville

If an unspecified status is left NULL (blank) then use a criterion of

IS NULL