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
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    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 use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+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. Using AutoNumber primary key on sorted column
    By grkatz823 in forum Access
    Replies: 7
    Last Post: 03-04-2013, 03:47 PM
  2. Replies: 1
    Last Post: 07-13-2012, 08:53 AM
  3. Copying fields includes column name
    By julioot in forum Access
    Replies: 14
    Last Post: 04-04-2012, 08:25 AM
  4. 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