RE: Only Return MAX AutoNum From relational Records

Hi All,

I'm going home now - will look at the posts later. Thanks.

CSR

Christopher Scott Rodgers wrote:
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

If autoNumMarketing is an Autonumber datatype, you can't 100% rely on it
being sequential. In other words, the largest autoNumMarketing might not be
[quoted text clipped - 4 lines]

Any help would be greatly appreciated.

.

Relevant Pages

  • Re: INSERT INTO With AutoNumber field
    ... autonumber key field. ... I have read a number of posts from 1997 to 2001 on Google Groups with this exact question and the answer being given to just ignore the autonumber field because the database will take care of it. ... Still don't know about the INSERT INTO and would be interested in anyone's insights there. ...
    (microsoft.public.access.queries)
  • Re: Controlling when a new record is generated
    ... you can't control that. ... Access is allowing you to add new records in a form, once you start typing ... >> autonumber is only designed to create a unique key, ... You can see previous posts by going to Google.com and clicking ...
    (microsoft.public.access.forms)
  • RE: Only Return MAX AutoNum From relational Records
    ... tblmarketing.autonumagy is really just a number and not an Autonumber ... The real problem that I am having ... however isnt with that. ... record for its associated agency. ...
    (microsoft.public.access.queries)
  • Re: Restart Autonumber
    ... > I have been reading many posts by users that claim to have years of ... I use Autonumber values as ... > primary keys for standalone tables, such as those that really do not ... > Autogenerated value is then stored in the OrderDetails records. ...
    (microsoft.public.access.formscoding)
  • Re: Restart Autonumber
    ... > I have been reading many posts by users that claim to have years of ... I use Autonumber values as ... > primary keys for standalone tables, such as those that really do not ... > Autogenerated value is then stored in the OrderDetails records. ...
    (microsoft.public.access.gettingstarted)