Results 1 to 8 of 8

filtering data for reports

  1. #1
    mejia.j88 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228

    filtering data for reports

    Hi guys,



    I have an Inspection form in which operators enter the Part Number, the quantity in (before inspection) and the quantity out after inspection.

    from this form, i created a report that shows the Yields by part number and by shift.
    ex.

    Day shift
    "part number 1" qtyin: 1000 QtyOut: 750
    "part number 2" qtyin: 2300 QtyOut: 200
    etc.
    etc.
    Night shift
    "part number 2" qtyin: 1000 QtyOut: 750
    "part number 4" qtyin: 2300 QtyOut: 200
    etc.
    etc.

    the problem is that certain part numbers belong to one category-Chips
    and the others to the category- Diodes.

    the report mixes the part numbers together presents them alphabetically.
    ideally, I would want it to show as:
    Day Shift:
    chips:
    part number whatever
    part number whatever

    Diodes:
    part number whatever
    part number whatever

    and similarly for nights.



    what is the best way to separate the these part numbers depending on the category they belong to because the information for the report is all in one database?

    any suggestions would help.

    thanks.

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I don't think this has anything to do with filtering, rather it is grouping and sorting.

    You don't say how you created your report, but here is a suggestion:
    Create a query that has all the information you need, including day/night shift, catgegory,part number and qty's.
    Then use the report wizard and base it on that query. Group by shift and category.

    If the report has already been created then you can manually add the groups (under Groups) and the sorting. The wizard is handy, however, as it creates total lines and all sorts of wonderful things for you!

  3. #3
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Access reports will handle a lot of the grouping for you. Your post suggests that you have taken advantage of one or maybe two levels of grouping. It's been a while since I did such a report, but I believe that levels of grouping are likely to be limited by formatting considerations before you exhaust the allowed groupings.
    One part of your question suggests you have only part numbers stored and would like text associated. If so, you may need to create a table of PartNames which details the relationship between part numbers and text names.

  4. #4
    mejia.j88 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    Aytee111- the reason i cant (at least i think i cant) group by category is because all part numbers are under one table.
    i think this leads into what hertfordkc was saying about creating a table of part names?

    thanks guys.

  5. #5
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    At this point, where the information is stored is not the problem. Did you create the query as I suggested? That is your starting point.

  6. #6
    mejia.j88 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    yes, the query i base my report off includes part numbers, quantities before and after inspection, date inspected (for shift references) etc.

  7. #7
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Create a report using the wizard based on that query - select the shift and category as items to group on.

  8. #8
    mejia.j88 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    hey guys,
    i made two seperate queries as suggested. and now my data is sorted correctly.

    the main report and sub report show the same information, but for different categories of parts. Main report shows for axial diodes, sub report for chip diodes.

    right now it is grouped and sorted in the following way: Date then workshift then part number, then shift date.

    i want the subreport to be displayed in a similar manner to where it corresponds to the date on the main report.

    i.e. right now, the subreport comes up on the end of the report. i want it to be linked? connected? displayed? by date.

    any ideas on how to do this?

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

Similar Threads

  1. Data filtering on a form
    By Sam4 in forum Forms
    Replies: 3
    Last Post: 11-23-2011, 05:14 PM
  2. Filtering Reports
    By JackA in forum Reports
    Replies: 2
    Last Post: 07-19-2011, 10:22 AM
  3. Unbound form for data filtering
    By alliandrina in forum Access
    Replies: 7
    Last Post: 05-21-2011, 05:19 PM
  4. Filtering/sorting data
    By jemelton in forum Access
    Replies: 5
    Last Post: 06-09-2010, 01:47 PM
  5. Filtering data
    By billybong in forum Access
    Replies: 1
    Last Post: 11-07-2009, 12:20 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
  •  
Tech Forums: Microsoft Office Forums