Results 1 to 5 of 5
  1. #1
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92

    Run Report with Prompt for Field Criteria

    I am new to creating reports, and am trying to have it so that everytime a report is being asked to run, a pop-up box asks for the user to specify a field criteria. The field will always be a date field that is populated.

    Can I do this on the switchboard?

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi diane802,

    Assuming you have a query supplying data to the report, add this (or something similar) to the date field criteria in the query:

    Code:
    =[Which Date? (Format mm-dd-yyyy)]
    Cheers,

  3. #3
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    This is perfect! Thank you!

  4. #4
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    how can i add into the header, that the date field is showing that date?

    I want it to show:

    Date: _________ and have it say the parameter value I typed in?

  5. #5
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Well, your date field will match whatever you entered in the pop-up, so just use the "date field" text box in your header. Something like this:

    [Label that says: "Date:"][Date Field Text box]

    Cheers,

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

Similar Threads

  1. Query multiple field & criteria
    By fua in forum Access
    Replies: 2
    Last Post: 11-04-2009, 08:22 PM
  2. prompt criteria issues
    By Rik_StHelens in forum Queries
    Replies: 1
    Last Post: 10-16-2009, 10:17 AM
  3. Replies: 1
    Last Post: 10-11-2009, 08:31 PM
  4. query - criteria based on another row field value
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 05-29-2009, 04:17 PM
  5. Setting criteria in a calculated date field
    By SteveReberger in forum Access
    Replies: 0
    Last Post: 10-29-2008, 06:58 AM

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