Retrieving records

[Phil]

Hi,

I have a database containing four fields:
Name
Earning
LastLoginDate
DateJoined

Extra notes for LastLoginDate:
Is being set at Text

I'm trying making a query that will contain:
Name:
LastLoginDate
DateJoined

Howeve, I want the query display all records that contain "never" string
value at
LastLoginDate

How can I do so by using Wizard or design mode?

If query is not possible then how do same thing for creating reports?

For your information, I am using Ms office 2000 for windows 98.

I do appreciate your reply, my email address is fake.

Therefore simply reply by using post.

 

[Guest]

Create a new query in design mode. Select your table as the data source.
Include all four of your fields. Under LastLoginDate, enter your string
under criteria and uncheck the "Show" box

 

[Phil]

Thank you.

Phil

Create a new query in design mode. Select your table as the data source.
Include all four of your fields. Under LastLoginDate, enter your string
under criteria and uncheck the "Show" box