RE: Only Return MAX AutoNum From relational Records

Thanks Jerry,

tblmarketing.autonumagy is really just a number and not an Autonumber
tblAgency.AutoNumAgy is an auto number. The real problem that I am having
however isnt with that. It is that I need to grab the most recent marketing
record for its associated agency. Karl indicated that I should use a left
join and TOP 1 . This will work if I can figure out how to do it when
tblMarket.AutoNumAgy = tblAgency.AutoNumAgy. The way I have it written now it
only collects one record from the whole table - not each most recent event
for each agency.

Thanks

CSR

Jerry Whittle wrote:
If autoNumMarketing is an Autonumber datatype, you can't 100% rely on it
being sequential. In other words, the largest autoNumMarketing might not be
the latest.
HI,

[quoted text clipped - 29 lines]

Any help would be greatly appreciated.

.

Relevant Pages

  • RE: Only Return MAX AutoNum From relational Records
    ... I'm going home now - will look at the posts later. ... Christopher Scott Rodgers wrote: ... tblmarketing.autonumagy is really just a number and not an Autonumber ... record for its associated agency. ...
    (microsoft.public.access.queries)
  • Re: how do I add an auto-number field to an existing database?
    ... type (so long as you don't already have an autonumber field in that table). ... > After I'd already started entering info into a new database, ... Isnt' there a way around this? ...
    (microsoft.public.access.tablesdbdesign)