Filtering

[vand_uk]

I need help…..
Say you’ve got a database that tracks jobs an employee is doing. How would you group all of a particular employees jobs together? If you’ve got a table of jobs, and the employees name is listed on a few different jobs how do u filter to just that employees jobs?

 

[KKilfoil]

Grouping together related records can be done easily by suitable sorting.

In a query that contains all of your relevent fields, the first (or 'leftmost') field in the query design grid that specifies a sort order is always sorted first, following by the second, etc.



Filtering in a query is easy as well. On the row for criteria, enter in whatever value you are seeking (in your case, a name). When the query is run, the result should be only those records that match your criterion.

You can have the query prompt for a name at run-time by using a parameter in the criteria space, such as "[Enter name]" (without the quotes).

You can even have the query get the desired value from a control on a form.

 

[vand_uk]

Thanks so much for that
how do i get the query to get the value from a value on a form?

 

[KKilfoil]

Use
[Forms]![YourFormName]![YourTextBoxName]