Results 1 to 3 of 3
  1. #1
    GregMc is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    2

    Sort by one column and print report that includes only the data within the sorted lines

    Hi


    I have a small shopping list database which has a form with two columns. The second column is a tick box thus enabling me to select items I need to buy. The two columns are labelled as "Item" and "Required". Also on the form is a button that is to print the shopping list. I want to sort the list by "Required" (alphabetically) then print the items that are required but not including items not "required".

    I'm not too smart at this but have got to this point by self teaching and would appreciate help with this please.

  2. #2
    Welshgasman is online now Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    621
    Create a query for the data with the criteria you require. use the Query wizard if needed.
    Save that query as qryShoppingList
    Use that query as the source of your report, and sort within the report.
    Save that report and print when needed.
    Please, please use # when posting code snippets.
    Cross Posting Etiquette: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



  3. #3
    GregMc is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    2
    Quote Originally Posted by Welshgasman View Post
    Create a query for the data with the criteria you require. use the Query wizard if needed.
    Save that query as qryShoppingList
    Use that query as the source of your report, and sort within the report.
    Save that report and print when needed.
    Thanks so much for your prompt reply - much appreciated. I'll give it a crack and see how I go but I reckon you're on the right track. Thanks again.

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

Similar Threads

  1. Column lines in Detail Section without Data
    By bijumathew in forum Reports
    Replies: 8
    Last Post: 08-17-2019, 12:16 AM
  2. Using AutoNumber primary key on sorted column
    By grkatz823 in forum Access
    Replies: 7
    Last Post: 03-04-2013, 03:47 PM
  3. Replies: 1
    Last Post: 07-13-2012, 08:53 AM
  4. Copying fields includes column name
    By julioot in forum Access
    Replies: 14
    Last Post: 04-04-2012, 08:25 AM
  5. Replies: 1
    Last Post: 02-29-2012, 04:46 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