Results 1 to 2 of 2
  1. #1
    leamas is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    May 2012
    Posts
    21

    Filtering Blanks, Report Parameter

    I've created a report that shows me all of my assets in each of my areas. Some assets do not have an area at the moment and are showing up on my report. Is there a way to leave this data out of my report?



    I have a second question regarding a parameter on my report. I would like for an "enter parameter" value to open once my report is clicked on, with the criteria being "area". My goal is to have the user click the report, type the area, and generate all assets in that given area.

    I appreciate all help in advance!

    Thanks.

  2. #2
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    I found this comment on another website about the matter:

    In Microsoft Access, to prevent records with blank fields from appearing in a report:

    1. Open your report in Design View.
    2. Right-click the square at the upper left, and then choose Properties.
    3. In Access 2010 and 2007, under "Property Sheet", click the General tab. In other versions of Access, in the Reports dialog box, select either the All tab or the Data tab.
    4. In the "Filter" text box, enter the text that you wish to filter. For example, if you wanted to leave out records where a field called "status" was blank, the filter would be: status <> ""
    5. Click inside the "Filter on Load" (Access 2010 and 2007) or "Filter On" (other versions) box, and then, from the drop-down menu, select Yes.
    6. Save your report, and then close it. From the View menu, select Layout Preview or Print Preview to view the filtered data.


    I hope it helps u

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

Similar Threads

  1. Conatenate fields and also remove blanks
    By Rubijon in forum Reports
    Replies: 3
    Last Post: 10-23-2011, 05:29 PM
  2. Fill in blanks from another table
    By HectorH in forum Queries
    Replies: 1
    Last Post: 08-26-2011, 05:13 PM
  3. SQL Update with blanks
    By Tyork in forum Programming
    Replies: 1
    Last Post: 12-17-2010, 10:12 AM
  4. Access filter does not show blanks
    By Jaricketts in forum Access
    Replies: 1
    Last Post: 03-26-2010, 05:38 PM
  5. Adding columns that contain blanks.
    By Tony McGuire in forum Access
    Replies: 11
    Last Post: 05-31-2009, 12:58 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