Recent content by cb1

  1. C

    Retrieved data from latest date.

    If I read your question properly it is as simple as below to get the latest date in a date/time. select max([yourTable.dateField]) as LatestDate from yourTable
  2. C

    Retrieved data from latest date.

    could you not use the max function?
  3. C

    Find Matched/Unmatched Query

    I'm trying to define what I was hoping would be a fairly simple query in an access DB, but running into a few difficulties on the best way to achieve the result I am after. Basically I have 2x tables. In each table are 3x fields of interest, empName, code, accountnumber. What I need to do is...
Top Bottom