Re: [MS_AccessPros] Parameter value

 

Thank Khalid,John Viescas

I added the parameter as a field in the report record source and it is OK    Thanks All

 

On Monday, February 3, 2014 6:59 PM, John Viescas <JohnV@msn.com> wrote:

 

Khalid-

Add the parameter as a field in the query that's the Record Source for your report, then use a text box to display the parameter entered on the report.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 3, 2014, at 5:33 PM, Khalid Tanweer <khalidtanweerburrah@yahoo.com> wrote:

Hi Ahmed,

According to my small knowledge you will have to set parameter in your query for the report.

You did not mentioned your field name? any how i assume it should be numeric field then you will have to put in criteria of the query Enter [Please enter the invoice lvalue] and if it is text field then it should be Like [Please enter the invoice value]

Moreover you should not show it on a label in your report, it should be on a textbox.

Best wishes,

Khalid

On Monday, February 3, 2014 8:56 PM, ahmad beshari <a1_beshari@yahoo.com> wrote:

 

Dears 

I have a report based on query, the query with the parameter "Please enter the invoice value" so when the user run the report it ask him first about the invoice value,what i want is to know which parameter value the user wrote before the report is views so i can show the value in a label in the report.

Thanks 

Ahmed 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (5)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___