CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Acess VBA code

  1. October 2nd, 2001, 03:06 PM #1
    amt35
    amt35 is offline Member
    Join Date
    Apr 2001
    Location
    Ridgecrest, CA.
    Posts
    41

    Acess VBA code

    I am using Access 2000:

    Is there a way to have some code search through a table computing the average of certain fields? I need to be able to do it at run time and from my main form.

    How do I get access to the entries in a table in VBA code?

    Thanks a lot!!!!

    Andrew

    Reply With Quote Reply With Quote
  2. October 2nd, 2001, 03:17 PM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: Acess VBA code

    Can you use SQL
    Select AVG(Field) as A from Table

    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured