Results 1 to 2 of 2
  1. #1
    maq is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    2

    how to comput in access for diff items

    i have access with vb.net application

    the application will show the result from the access

    i have electricalcable as database name

    the table called cabletest

    i have 17 cable under the cabletype column

    im my vb.net form i have combo box that will show the name of the cable

    under cabletype column

    i have
    textbox1=average

    textbox2=max



    textbox3=min

    textbox4=Positive

    textbox5=Negative

    how to do it if i have 17 different cables

    is there away that when the combo box show the name of the cable it will comput average ,max,min

    i do not know how to start it.

    do i have to do query for every cable ?


    thank you for your help.

    i add example for one of the cable in the access database




  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    None of this looks easy. Probably involves TOP keyword in SELECT query. Also, calculations between records. Check this for info on both.
    http://allenbrowne.com/subquery-01.html#AnotherRecord
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-29-2012, 01:33 AM
  2. Different Prices for diff customers
    By kerrin in forum Access
    Replies: 4
    Last Post: 12-31-2011, 07:50 PM
  3. Date diff trouble
    By Cran29 in forum Queries
    Replies: 3
    Last Post: 03-11-2011, 01:02 PM
  4. Replies: 2
    Last Post: 09-22-2010, 09:26 AM
  5. Check time Diff.
    By wes028 in forum Access
    Replies: 3
    Last Post: 03-08-2010, 10:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums