Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Field Names (97)

    Hi,
    I've changed a field name in a table. I have also updated the field name references in queries that pull from that table and reports that pull from the queries. The updated queries work fine, but the reports pop up a parameter query for the old field name. (I can leave the parameter pop up blank, click OK, and then the report displays as it should.) There is no reference in the report to the old field as far as I can tell.

    Any thoughts about what I have missed that is keeping this from working?

    Thanks.

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Field Names (97)

    Check in the Grouping/Sorting dialog
    Check any formulas for calculations
    Happy Hunting... <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Location
    California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Field Names (97)

    Steve,
    The Grouping/Sorting one was the problem - thanks for the quick reply.

Posting Permissions

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