Search results

  1. M

    MAX Date query - how to have a 'unique' date?

    Thank you for your quick reply Bodisathva. Unfortunately your suggestions don't work. I am needing to choose between equal values eg. John & Bob both visit Acme Ltd on 10/05/2007. Both enter visits into the Access database, so there are 2 'last' visits to Acme Ltd whereas I only want to display...
  2. M

    MAX Date query - how to have a 'unique' date?

    My database holds details of visits made to customers by support staff. I am running a query which returns details of the last visit made to a customer as below with results displayed on a webpage. SELECT Visits.Date1, customers.CustID AS customers_CustID, customers.Customer, Visits.CustID AS...
Back
Top Bottom