Results 1 to 4 of 4
  1. #1
    kharro
    Guest

    Transferring values (Access 2000)

    I have created 6 calculated expressions on a form which return 6 numeric values. How do I transfer these values to a table or query so I can use them in the Chart Wizard.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Transferring values (Access 2000)

    Is the form bound or unbound? If it's bound, you can use code to set hidden controls' values to the results of the expressions. Otherwise, you'll need to provide more information about exactly what you're trying to do in order to get a useful answer.
    Charlotte

  3. #3
    kharro
    Guest

    Re: Transferring values (Access 2000)

    Charlotte

    It is a bound form. The calculated expressions are used to obtain several numeric values - based on a field - eg how many greater than 100, how many greater than 200, how many greater than 300, etc. I want to then use the return values from these expressions (6 in all) in a chart in Access. But I am at a loss as to how I can 'use' these return values outside of the form.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Transferring values (Access 2000)

    I don't understand. Is the chart on the form or what? Why don't you just use a query that calculates the same values as the datasource for your chart?
    Charlotte

Posting Permissions

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