Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: adding qry value to report text box

    i have a qry : qryMidToday it returns 1 value alias :MidToday

    I have a report based on a table, i want to add a text box and put the results from qryMidToday in that txt box, im using access 2000, i tried:

    =[qryMidToday]![MidToday] but when i try to view the rpt i get a Enter paramater value prompt requesting qryMidToday.

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Try DLookup.
    Code:
    =DLookup("MidToday", "qryMidToday")
    I think that will give you want you are looking for.

  3. #3
    Join Date
    Oct 2003
    Posts
    233
    great thanks~!

Posting Permissions

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