Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Last Date query (Access 2007)

    I have a DuesTable for an organisation database. Each month I need to create new dues records taking into account members who have resigned etc. The Dues record has a date field, which is in dd/mm/yyyy format. This field holds date as at first of the month. I want to create an append query which will select ONLY those records from the latest month, and using dateadd create a new record for the next month. In testing using a select query, I have tried using max([Month]) as selection criteria in Month field but get error "Cannot have aggregate function in WHERE clause tblDuesRecords.Month=Max([Month])"

    Would appreciate being shown the error of my ways!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Last Date query (Access 2007)

    Have a look at the thread beginning with <post#=740,930>post 740,930</post#>
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Last Date query (Access 2007)

    I saw that but because it dealt with amounts rather than dates, I ignored it. Will investigate. Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •