Need help in DLookup function in MS Access Query

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

I need help in Dlookup funciton in MS Access query. My specs are the
following
List Tester names
Who are not assigned to any test between Test Begin Date and Test End
Date

The query will show only one column "Tester names" and i want the list
of tester names who are not assigned to any test between Test begin
Date and Test End date.


Any help would be greatly appreciated.

Thanks

Moe
 
Good info, but what does the table you are querying look like? For example,
how do you know what tasks a tester is assigned to? Does his assignment
include begin an end dates?, also include table layout.
 
DLookup does not return a list, it returns a single value.
You should look in Access HELP for what DLookup does.

To return a list you need a query - which will return a result set.
How you do this depends on what you are going to do with the data returned.
Are you going to display it in a subform, listbox or what?

-Dorian
 
Back
Top