Share via

Unable to use the Sum function in access visual basic

Anonymous
2016-05-14T19:49:56+00:00

Have a vb program which i am trying to use the Sum function but am unable. Compiler says not defined, Think there is a reference i need to a library. Any one got a idea? TIA

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,091 Reputation points MVP Volunteer Moderator
    2016-05-17T01:38:55+00:00

    That's the way you would do it in Excel, and maybe that would be a good choice for you.

    Access is not Excel on steroids, and your comment "Have no idea what a relational db is" means you either learn it, or abandon it. Having an incorrect database design is "the gift that keeps on giving" and you really cannot build a successful application on it.

    Unlike the other Office products - say PowerPoint, which you can just open and start hacking away at, Access is not such a product. It requires study and knowledge before you can do even one thing right.

    So while we don't want to discourage anyone from taking up Access, it's time to fish or cut bait.

    0 comments