Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Reports

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-02-2006, 04:23 AM
Novice
 
Join Date: Nov 2005
Posts: 12
fadone
Default How to Display parameter values on the report

I have a report that is based on an underlying query.At the query level,I have defined parameters of date data type so that records to be displayed should fall between DateA and Date B.ie Between[Enter Date A:] And [Enter Date B:].How can I display these two parameter values on the report header???
Reply With Quote
  #2  
Old 01-03-2006, 03:37 PM
Expert
 
Join Date: Dec 2005
Location: Wilmington, DE - USA
Posts: 275
matthewspatrick
Send a message via MSN to matthewspatrick
Default

In your report (probably in the report header or in the page header) put an unbound textbox, with this as the ControlSource:

="Data for dates between " & Format([Enter Date A:], "mmmm d, yyyy") & " and " & Format([Enter Date B:], "mmmm d, yyyy")

The key is to use the exact same name for the parameters.
Reply With Quote
  #3  
Old 01-04-2006, 02:32 AM
Novice
 
Join Date: Nov 2005
Posts: 12
fadone
Default

Quote:
Originally Posted by matthewspatrick
In your report (probably in the report header or in the page header) put an unbound textbox, with this as the ControlSource:

="Data for dates between " & Format([Enter Date A:], "mmmm d, yyyy") & " and " & Format([Enter Date B:], "mmmm d, yyyy")

The key is to use the exact same name for the parameters.
Thanks mathews.
However, I have tried your solution but the output doesnt bound to the parameters entered.ie it shows records which are out of specified date range.
I just cant figure out how would above expression is going to reflect the related Date control.
Reply With Quote
  #4  
Old 01-04-2006, 05:46 AM
Expert
 
Join Date: Dec 2005
Location: Wilmington, DE - USA
Posts: 275
matthewspatrick
Send a message via MSN to matthewspatrick
Default

Please download the following file and see how I set up the report. It is a very simplistic example, but it illustrates the advice I gave you.

http://www.geocities.com/matthewspat...rums255946.zip
Reply With Quote
  #5  
Old 01-04-2006, 11:36 PM
Novice
 
Join Date: Nov 2005
Posts: 12
fadone
Default Thanks!

Thanks very much mathews.it is working fine!!!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter Parameter Value plesser Access 1 11-08-2008 07:27 AM
calculate difference of $$ than can display in the subtotals in a report taniuca Queries 0 08-07-2008 05:02 PM
Counting Values at end of report minus certain records Blake Reports 1 11-11-2006 05:00 PM
Date Parameter shakira Queries 2 03-09-2006 09:55 AM
DISPLAY INPUT PARAMETERS ON THE REPORT fadone Forms 1 12-09-2005 07:26 PM


All times are GMT -8. The time now is 08:22 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.