Results 1 to 2 of 2
  1. 04-01-2010, 12:12 PM #1
    chu3w
    chu3w is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    3

    Text Box to show specific record


    Hi, Can I make the text box on a form to show data from a specific record? For example, I have a table with two fields Quarter and Revenue. Can I make the text box to show just the data for revenue in Quarter3?
    Reply With Quote Reply With Quote
  2. 04-01-2010, 12:23 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    One way might be a DLookup() or DSum() formula:

    DLookup Usage Samples
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Query Out Specific Text
    By ysabella in forum Queries
    Replies: 1
    Last Post: 11-19-2015, 03:53 AM
  2. specific record
    By thewabit in forum Access
    Replies: 8
    Last Post: 02-17-2010, 11:32 PM
  3. Print a specific record report from a form
    By cynthiacorley in forum Reports
    Replies: 27
    Last Post: 02-08-2010, 06:34 AM
  4. Creating a Switchboard button - search for record and open up specific form / report
    By diane802 in forum Access
    Replies: 3
    Last Post: 01-14-2010, 08:32 AM
  5. How to show new record at the top of a subform
    By kabichan in forum Access
    Replies: 4
    Last Post: 10-29-2008, 11:53 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums