Results 1 to 5 of 5
  1. #1
    grapevine is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    22

    Create a Heading based on the Parameter Query


    I have created several parameter queries successfully linking to a view.
    Is there any way that I can create a heading such as List of Records for xxx where xxx is the name selected in the parameter query, rather than having a long list of the same name appearing in the results.
    Many thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,345
    In the query, make the header caption field you gave:

    Caption: "List records in " & [Enter Caption]

  3. #3
    grapevine is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    22
    sorry, I should have specified that I am using Web Apps. Does this still apply? I am no sure where to put in as there is no heading field in the view
    Many thanks

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,345
    Make a query using the view. Add this field.

  5. #5
    grapevine is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    22
    Thank you, much appreciated

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-21-2015, 03:38 PM
  2. Replies: 5
    Last Post: 03-02-2015, 03:07 PM
  3. Replies: 1
    Last Post: 05-15-2013, 09:09 PM
  4. Replies: 1
    Last Post: 04-05-2013, 01:58 PM
  5. Replies: 1
    Last Post: 10-22-2012, 05:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums