1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access subform

Discussion in 'Business Applications' started by wdisneymom, Apr 5, 2004.

Thread Status:
Not open for further replies.
  1. wdisneymom

    wdisneymom Thread Starter

    Joined:
    Jan 21, 2001
    Messages:
    283
    I have a form and in it is a subform with student's grades
    How can I query this so I can show the last entry only
     
    wdisneymom, Apr 5, 2004
    #1
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,551
    Create a Join Query between the 2 tables. On the View menu click "Totals" (while in Design view) then on the grid area select "Last" under the column for the appropriate field from the "Totals" row.

    Ziggy
     
    Ziggy1, Apr 5, 2004
    #2
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Access subform
  1. desertrose152

    #name error access

    desertrose152, Nov 8, 2019 at 5:59 PM, in forum: Business Applications
    Replies:
    1
    Views:
    54
    Chawbacon
    Nov 8, 2019 at 7:39 PM
  2. Dubravka

    Access 2013 combo box not working on new workstation

    Dubravka, Nov 7, 2019 at 4:40 PM, in forum: Business Applications
    Replies:
    1
    Views:
    78
    Chawbacon
    Nov 8, 2019 at 7:49 PM
  3. Johnshin111

    Accessing 2000 with SP6A

    Johnshin111, Nov 7, 2019 at 4:47 AM, in forum: Business Applications
    Replies:
    1
    Views:
    51
    lochlomonder
    Nov 7, 2019 at 5:50 PM
  4. SoldierC

    #NAME in Access

    SoldierC, Oct 22, 2019, in forum: Business Applications
    Replies:
    2
    Views:
    288
    Fireflycph
    Nov 3, 2019
  5. Genc888

    How to access a business app from anywhere

    Genc888, Oct 2, 2019, in forum: Business Applications
    Replies:
    1
    Views:
    473
    cwwozniak
    Oct 2, 2019
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/217278

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice