Search:

Type: Posts; User: Dbc23; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    8
    Views
    1,065

    Re: Trying to average last 3 records only (top 3)

    I was able to pull the code for the SP and tried re-implementing it in Access, both via an access query and running a Pass-Through but neither would work, had all sorts of execution and/or connection...
  2. Replies
    8
    Views
    1,065

    Re: Trying to average last 3 records only (top 3)

    HAH, that's actually how i have it working now. It's just averaging a recent time span and giving them a number, which is a pretty good estimate. this database drives a piece of CRM front-end...
  3. Replies
    8
    Views
    1,065

    Re: Trying to average last 3 records only (top 3)

    I tried that a few ways but couldn't seem to get it to work. Whenever I created the sub-query they would only return the top 3 records in total, so when I try linking the key fields all but 3...
  4. Replies
    5
    Views
    904

    Re: MS Access auto/scheduled report export.

    Totally, it actually simplifies it.

    So you have your query created "querywhatever"

    You now create a function in VBA (a sub should work, but for some reason I got less issues when it's a...
  5. Replies
    8
    Views
    1,065

    Trying to average last 3 records only (top 3)

    So I'm trying to create a query that will produce an average (totals) column based on the TOP 3 records associated with two other key field values. Basically an average of the three most recent...
  6. Replies
    5
    Views
    904

    Re: MS Access auto/scheduled report export.

    If I'm understanding correctly you need to send the excel export of the access query to someone routinely?

    If so, this is something (after a lot of learning) I've managed to do quite effectively...
Results 1 to 6 of 6