Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Wickleh - Ireland
    Posts
    2

    Unanswered: Access Projects Report error

    Hows it going!

    We've just upsized our MS Acess database to MSDE and are using an Access Projects ADP front end.
    Im trying to convert all our old reports to run on this new Access PRojects front end
    and I'm running into problems.

    In my Access Projects Report, I cannot use any aggregate functions, sum, avg in the control source of textboxes unless the control source
    is a field from the stored procedure linked to the form, I was able to use these functions on any textbox in regular Access, but now
    I get Error messages like "Column ???? does not exist in appropriate rowset" or "Aggregate Functions are only allowed on on output fields of the recordsource"

    Im new to Access Projects but is this normal? These functions work in the control sources of textboxes in our old Access front end,
    Is there a way to work around these functions not working in Access Projects
    or am I going to have to code a load of Sums and Avgs etc in VBA to work these numbers out?

    Anyways any help would be appreciated!

    Thanks!

  2. #2
    Join Date
    Oct 2004
    Location
    Wickleh - Ireland
    Posts
    2
    ..........

Posting Permissions

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