Results 1 to 3 of 3
  1. #1
    Degs29 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2013
    Posts
    38

    Custom report based on partial data from a field

    I have 150 specific items displayed in a report with quantities listed for each. What I want is to create additional custom reports based on criteria in the "Item" field. As an example:

    Item: ---- Quantity:

    A B C I ------ 3
    A C D B ------ 7
    Y R S A ------ 9


    N M E S ----- 40
    B E D A ------ 3
    N M D E ----- 20

    How would I create a custom report that only returns data for items with "B" in the name (ABCI, ACDB, and BEDA)?

  2. #2
    AlexHedley's Avatar
    AlexHedley is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    England
    Posts
    180

    Custom report based on partial data from a field

    Add a Criteria in the ITEM Field of
    LIKE "*B*"

  3. #3
    Degs29 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2013
    Posts
    38
    Quote Originally Posted by AlexHedley View Post
    Add a Criteria in the ITEM Field of
    LIKE "*B*"
    Yeah, I may have been premature with that question as it was rather simple once I thought about it. Thanks anyway!

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

Similar Threads

  1. Replies: 3
    Last Post: 05-26-2013, 03:07 PM
  2. Creating a report based on partial field search
    By pirseinkim in forum Reports
    Replies: 1
    Last Post: 03-22-2013, 11:08 AM
  3. Replies: 2
    Last Post: 03-07-2013, 04:50 PM
  4. Return results based on a partial search
    By TimMoffy in forum Queries
    Replies: 2
    Last Post: 07-27-2012, 11:09 AM
  5. Partial Matching based Queries
    By Yatesb in forum Queries
    Replies: 0
    Last Post: 02-23-2009, 01:06 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