F fordy Registered User. Local time Today, 04:40 Joined Mar 12, 2002 Messages 36 Mar 16, 2002 #1 If i set a paremeter query, how do I get the selected paremeter that the user has chosen to show in a report I know the sql for dates - beggining and end but not others
If i set a paremeter query, how do I get the selected paremeter that the user has chosen to show in a report I know the sql for dates - beggining and end but not others
Graham T Registered User. Local time Today, 04:40 Joined Mar 14, 2001 Messages 300 Mar 18, 2002 #2 Use unbound text boxes in your report. Enter the parameters for example, as entered into your query: =[Enter Start Date] This will insert what the user has entered as their parameter. HTH
Use unbound text boxes in your report. Enter the parameters for example, as entered into your query: =[Enter Start Date] This will insert what the user has entered as their parameter. HTH