Building a select query

  • Thread starter Thread starter northstar
  • Start date Start date
N

northstar

I have a table that lists all customers and when service was performed on
their equipment. I built a Totals query that identifies all service performed
in the previous year (grouping service date by "Max"); but I still get
multiple visits showing in the same year, e.g. 2008. I do not know any
programming language, so how can I build the query to give me only the most
recent date?
Thanks from a novice.
 
Look through the output of your query for a column that has
all different values. A good candidate is any date field that
includes the time. Grouping on that will foil any attempt at
totals. Same for ID numbers. They are unique. Don't include
them in the totals query.
 
I have a table that lists all customers and when service was performed on
their equipment. I built a Totals query that identifies all service performed
in the previous year (grouping service date by "Max"); but I still get
multiple visits showing in the same year, e.g. 2008. I do not know any
programming language, so how can I build the query to give me only the most
recent date?
Thanks from a novice.
Click to expand...

Please open your query in design view; select View... SQL; and post the SQL
text here. I'm sure it's fixable but can't see the query from here!
 
Back
Top