Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    31

    Unanswered: Need a box in a form that gets it's info from a query.

    Hello,

    I am trying to set up a form to run reports off of for our dept. I would like to add the department's avg to the form in a field box that update's when the form is opened. I have a query that calculates the dept avg but I am unsure how to add this query's result to this field box. Does anyone know how I can do this? I am fairly new to access and am running '97.

    thanks

  2. #2
    Join Date
    Feb 2004
    Posts
    142
    =Dlookup("[FieldName]","Table or Query Name","[FieldName] = " & someVal)

    The criteria (third) section is optional.
    KC

Posting Permissions

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