Results 1 to 6 of 6
  1. #1
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92

    Field Sorting on Reports

    Hi,

    I have two issues:

    1. On my report, I only want to show data that has "Positive" with it. Can you please let me know where and how I can do this?


    2. I am having extra/blank pages on the report. Only the odd pages have data and for some reason even pages are empty.

    Thanks,
    netchie

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    1. Filter the data source report is bound to. Several ways to accomplish this. You can put this criteria into a query that is the RecordSource for report. You can pass this filter value to report by parameter reference to box on a form where user enters this value. You can use the WHERE argument of DoCmd.OpenReport to filter the report's RecordSource.

    2. Blank pages may be because report formatted larger than paper area.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92
    Hi June7,

    I am honestly new to Access, I don't know what you just said for my Issue#1 . Is it ok to give m ethe step-by-step on this? What I have is rptSystemSort. One of the fields name on the report is Status. When i print the report, the status shows everything. should I change the report in Design View and double click the Status field? Where should I go after that? What command should I put?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    You need to filter the report's RecordSource to include only records with a Positive value. A report's RecordSource can be a saved Access query or an SQL statement. What is in the RecordSource property of your form?

    Access Help has guildelines on how to create a filtered report. Also, here is a tutorial for starters http://www.blueclaw-db.com/accessque...ter_report.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92
    Hi June 7,

    Thanks for the link. Still alien explanation to me but I appreciate your time giving the link. I guess it's true that Access is not my thing since I'm a newbie

    Thanks,
    netchie

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    You need to get basic concepts understood before we can help you much. A user forum is not the place to try learning basics. Building a filtered report in Access is elementary functionality. I am not going to even try to outline step-by-step instructions for basics when there are already plenty of resources available. You should study a basics tutorial book and explore some project templates (Microsoft has a whole library of projects).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-29-2011, 11:42 AM
  2. Sorting on field other than primary key
    By usmcgrunt in forum Access
    Replies: 24
    Last Post: 08-30-2010, 07:15 PM
  3. Sorting a Report by a Calculated field
    By mulefeathers in forum Reports
    Replies: 1
    Last Post: 05-22-2010, 08:21 PM
  4. Generating reports by incomplete field
    By mathonix in forum Reports
    Replies: 2
    Last Post: 01-28-2010, 06:37 PM
  5. sorting a field in report
    By Philangr8 in forum Reports
    Replies: 3
    Last Post: 08-26-2009, 05:38 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