Results 1 to 4 of 4
  1. #1
    leejqs is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    8

    Simple Report by Month

    I am building a very simple database for a healthcare firm, organizing their potential leads and candidates. I have a report set up as a potential participant log which shows the lead's name and all the dates in which they have interacted with the firm (initial contact date, tour date, info sent date, etc.) However, I am an Access noobie. I want the report to only show contacts who have initial contact dates from a given month. Any suggestions??



    Thanks!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can use the WhereCondition argument of the OpenForm command to apply a filter to the RecordSet of the report.

  3. #3
    leejqs is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    8

    Thank You

    Thanks RG, I will definitely look into this. I hope I can make it work!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Post back in this thread if you need more assistance on this issue.

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

Similar Threads

  1. Please help w/ simple languages db
    By TalentNation.net in forum Database Design
    Replies: 0
    Last Post: 01-23-2009, 09:11 AM
  2. SQL Query by day to end of month
    By tcasey in forum Queries
    Replies: 0
    Last Post: 10-07-2008, 09:55 PM
  3. Total no of days in a month
    By wasim_sono in forum Forms
    Replies: 4
    Last Post: 10-15-2006, 01:05 PM
  4. "Previous Month" button
    By allochthonous in forum Programming
    Replies: 3
    Last Post: 09-10-2006, 12:15 PM
  5. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 PM

Tags for this Thread

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