Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2003
    Columbia, MO

    Angry Unanswered: Graph from a query based on an unbound form

    I am trying to make a graph that is based off of a union query which is based off of 2 queries that pull input from about 6 fields, of which 3 fields, (year, sex, weight) come from an unbound form. I deal with cattle prices and numbers, and so I wanted to be able to compare a selected year's cattle prices by week to the average price by week for all the years in the database. The queries work fine, but when I try to build a chart off the combined union query, I get the following message:

    The Microsoft Jet Database engine does not recognize '[Forms]![frmMOWWAPriceComparison]![Year]' as a valid field name or expression.

    I have messed with it trying different things, and I can get the same message for the sex and weight fields as well. If any of you fine folks can help me out, I would greatly appreciate it.

    Last edited by decad1; 02-14-03 at 12:13.

Posting Permissions

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