How to edit pivot table calculated field

Discussion in 'Microsoft Access Forms' started by Guest, Jun 15, 2005.

  1. Guest

    Guest Guest

    How do I get to see or change the definition of one?

    Here's the problem - I have a form based on a table.

    Some time ago I created a pivot table on it, it has a total field called Rcvd
    Net.

    I put it into a table and right click and look at its properties. the
    properties says
    "total source field" is Net Receipt. Net Receipt is not a field in my data
    source and is not visible on my form anywhere. How do I get at that "field"
    and verify or change its definition?

    If I try and create a new field called "Net Receipt" it disallows it saying
    the field already exists.

    --
    William Hite
    http://www.searchfavorites.com
    Office Automation Consultant and Developer
     
    Guest, Jun 15, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    2
    Views:
    478
    John Vinson
    Jan 14, 2004
  2. Deb

    calculated date field as default in a bound field

    Deb, Feb 9, 2004, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    337
    Wayne Morgan
    Feb 9, 2004
  3. john

    edit calculated field

    john, Mar 25, 2004, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    247
    John Vinson
    Mar 25, 2004
  4. Dan

    Edit a calculated field ????

    Dan, May 14, 2004, in forum: Microsoft Access Forms
    Replies:
    4
    Views:
    948
    Mike Painter
    May 16, 2004
  5. Guest

    Assigning a calculated field to field table.

    Guest, Jun 17, 2004, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    266
    Guest
    Jun 17, 2004
  6. Guest

    Assigning a calculated field to field table.

    Guest, Jun 17, 2004, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    215
    Guest
    Jun 17, 2004
  7. Guest
    Replies:
    1
    Views:
    1,278
    Al Campagna
    Mar 9, 2007
  8. Dan

    Edit Calculated Text Field

    Dan, Jan 17, 2008, in forum: Microsoft Access Forms
    Replies:
    9
    Views:
    199
    Klatuu
    Jan 18, 2008
Loading...