Criteria- Help Please

[Guest]

I have a query setup with a field for emplyee IDs. I want to be able to retreive one employee at a time or view them all at once. My first criteria states [Please Type EmployeeID:] and that allows me to enter an employee id to pull up that specific record. However, i'm not sure what to put in the "Or" criteria to be able to retreive all employee data at once. Please assis

Thanks
Ray

 

[fredg]

I have a query setup with a field for emplyee IDs. I want to be able
to retreive one employee at a time or view them all at once. My
first criteria states [Please Type EmployeeID:] and that allows me
to enter an employee id to pull up that specific record. However,
i'm not sure what to put in the "Or" criteria to be able to
retreive all employee data at once. Please assist

Thanks, Ray

Like IIf(IsNull([Enter ID]),"*",[Enter ID])

Either don't enter anything and get all records, or enter just the one
ID and get that one record.

 

[Guest]

Fred, worked like a charm. thanks for your assistance!!!!