Select Distinct

  • Thread starter Thread starter eb1mom
  • Start date Start date
E

eb1mom

I want to create a query that will return all records with
a distinct value in "ToolField". Query is based on tool
check out table. A form will be created from this query and
additional information will be added. Thanks
 
My prior post was very skimpy.I do have the query created
just can't get "select distinct" for ToolField. Field has
same tool name many times I only want each tool name once.
The table that the query is based on is sorted by date so
this query would give me records for the last time each
tool had been checked out. Thanks
 
Don't use destinct. for your situation i think you may
want to last. be careful. you may need to use it on more
than one field.
Select Last([toolfield].[field])as Lasttimeused from
Toolfield
If you are using the query grid, click in the field then
click the sigma icon on the tool bar. in the field
column,click in the totals row. change group by to last.
 
Back
Top