Prev: Report with Monthly rows, Yearly columns & 3 pieces of data pe
Next: Chart based on data from report
From: Rohn on 1 Jul 2008 09:43
Is it possible to display and print the Query Parameter on a chart? I
would like to have the Year and Month that the user selected displayed and
printed on the chart! but can't figure out how. Here are the two query
fields and the parameters.

Query is: Year: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"yyyy")
Parameter: Like [Type year 2006, 2007, or 2008] & "*"

Query is: Month: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"mmm")
Parameter: Like [Type Jan, Feb, or Mar for Month] & "*"


Thanks to all of you gurus who spend time helping people like me!
Rohn


From: Rohn on 1 Jul 2008 09:51
I did just see this posting. But I don't have a form set up for selection,
DO I NEED TO?

"Matt Wickham" <mrwick(a)discussions.microsoft.com> wrote in message
news:<32C8A5F3-789F-47C9-AF10-1998D7EF3684(a)microsoft.com>...
> If your query uses a form (like Report Date Range) to prompt for the date,
> you can add a text box in design mode in the report header with a Control
> Source of something like:
>
> ="For Data Between: " & Format([Forms]![Report Date Range]![Beginnining
> Date],"m/d/yy") & " and " & Format([Forms]![Report Date Range]![Ending
> Date],"m/d/yy")
>
> --
> ProRules, LLC
> www.prorules.com





"Rohn" <rohn(a)msn.com> wrote in message
news:eMdLCC42IHA.2524(a)TK2MSFTNGP04.phx.gbl...
> Is it possible to display and print the Query Parameter on a chart? I
> would like to have the Year and Month that the user selected displayed and
> printed on the chart! but can't figure out how. Here are the two query
> fields and the parameters.
>
> Query is: Year: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"yyyy")
> Parameter: Like [Type year 2006, 2007, or 2008] & "*"
>
> Query is: Month: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"mmm")
> Parameter: Like [Type Jan, Feb, or Mar for Month] & "*"
>
>
> Thanks to all of you gurus who spend time helping people like me!
> Rohn
>


From: Douglas J. Steele on 1 Jul 2008 10:57
No, you can refer to your parmeter names:

="For data in " & [Type Jan, Feb, or Mar for Month] & " of " & [Type year
2006, 2007, or 2008]

Just make sure you type the prompts exactly the same in both places!

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rohn" <rohn(a)msn.com> wrote in message
news:OGnMCG42IHA.4800(a)TK2MSFTNGP02.phx.gbl...
>I did just see this posting. But I don't have a form set up for selection,
>DO I NEED TO?
>
> "Matt Wickham" <mrwick(a)discussions.microsoft.com> wrote in message
> news:<32C8A5F3-789F-47C9-AF10-1998D7EF3684(a)microsoft.com>...
>> If your query uses a form (like Report Date Range) to prompt for the
>> date, you can add a text box in design mode in the report header with a
>> Control Source of something like:
>>
>> ="For Data Between: " & Format([Forms]![Report Date Range]![Beginnining
>> Date],"m/d/yy") & " and " & Format([Forms]![Report Date Range]![Ending
>> Date],"m/d/yy")
>>
>> --
>> ProRules, LLC
>> www.prorules.com
>
>
>
>
>
> "Rohn" <rohn(a)msn.com> wrote in message
> news:eMdLCC42IHA.2524(a)TK2MSFTNGP04.phx.gbl...
>> Is it possible to display and print the Query Parameter on a chart? I
>> would like to have the Year and Month that the user selected displayed
>> and printed on the chart! but can't figure out how. Here are the two
>> query fields and the parameters.
>>
>> Query is: Year: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"yyyy")
>> Parameter: Like [Type year 2006, 2007, or 2008] & "*"
>>
>> Query is: Month: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"mmm")
>> Parameter: Like [Type Jan, Feb, or Mar for Month] & "*"
>>
>>
>> Thanks to all of you gurus who spend time helping people like me!
>> Rohn
>>
>
>


From: Rohn on 1 Jul 2008 11:55
I tried [Year] which is the parameter name and I get #Name? in my text box
in the chart? Obviously, I am doing something wrong! So I tried using the
Expression Builder with this: = [(Q)Chart_System]![Year] and get the same
#Name? error.

What did I miss?

Thanks again for the assistance,
Rohn

"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_canada.com> wrote in message
news:OsvCYr42IHA.3384(a)TK2MSFTNGP04.phx.gbl...
> No, you can refer to your parmeter names:
>
> ="For data in " & [Type Jan, Feb, or Mar for Month] & " of " & [Type year
> 2006, 2007, or 2008]
>
> Just make sure you type the prompts exactly the same in both places!
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Rohn" <rohn(a)msn.com> wrote in message
> news:OGnMCG42IHA.4800(a)TK2MSFTNGP02.phx.gbl...
>>I did just see this posting. But I don't have a form set up for
>>selection, DO I NEED TO?
>>
>> "Matt Wickham" <mrwick(a)discussions.microsoft.com> wrote in message
>> news:<32C8A5F3-789F-47C9-AF10-1998D7EF3684(a)microsoft.com>...
>>> If your query uses a form (like Report Date Range) to prompt for the
>>> date, you can add a text box in design mode in the report header with a
>>> Control Source of something like:
>>>
>>> ="For Data Between: " & Format([Forms]![Report Date Range]![Beginnining
>>> Date],"m/d/yy") & " and " & Format([Forms]![Report Date Range]![Ending
>>> Date],"m/d/yy")
>>>
>>> --
>>> ProRules, LLC
>>> www.prorules.com
>>
>>
>>
>>
>>
>> "Rohn" <rohn(a)msn.com> wrote in message
>> news:eMdLCC42IHA.2524(a)TK2MSFTNGP04.phx.gbl...
>>> Is it possible to display and print the Query Parameter on a chart? I
>>> would like to have the Year and Month that the user selected displayed
>>> and printed on the chart! but can't figure out how. Here are the two
>>> query fields and the parameters.
>>>
>>> Query is: Year: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"yyyy")
>>> Parameter: Like [Type year 2006, 2007, or 2008] & "*"
>>>
>>> Query is: Month: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"mmm")
>>> Parameter: Like [Type Jan, Feb, or Mar for Month] & "*"
>>>
>>>
>>> Thanks to all of you gurus who spend time helping people like me!
>>> Rohn
>>>
>>
>>
>
>


From: Rohn on 1 Jul 2008 16:42
This is a Chart without a Record Source for the data. and in the Detail
section is the "OLEUnbound0" Chart and the row source set to: SELECT
[Category_A],Sum([CountOfCategory_A]) AS [SumOfCountOfCategory_A] FROM
[(Q)Chart_System] GROUP BY [Category_A];

This might help figure out why I can not view a reference to my query
parameters.

Thanks, Rohn

"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_canada.com> wrote in message
news:OsvCYr42IHA.3384(a)TK2MSFTNGP04.phx.gbl...
> No, you can refer to your parmeter names:
>
> ="For data in " & [Type Jan, Feb, or Mar for Month] & " of " & [Type year
> 2006, 2007, or 2008]
>
> Just make sure you type the prompts exactly the same in both places!
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Rohn" <rohn(a)msn.com> wrote in message
> news:OGnMCG42IHA.4800(a)TK2MSFTNGP02.phx.gbl...
>>I did just see this posting. But I don't have a form set up for
>>selection, DO I NEED TO?
>>
>> "Matt Wickham" <mrwick(a)discussions.microsoft.com> wrote in message
>> news:<32C8A5F3-789F-47C9-AF10-1998D7EF3684(a)microsoft.com>...
>>> If your query uses a form (like Report Date Range) to prompt for the
>>> date, you can add a text box in design mode in the report header with a
>>> Control Source of something like:
>>>
>>> ="For Data Between: " & Format([Forms]![Report Date Range]![Beginnining
>>> Date],"m/d/yy") & " and " & Format([Forms]![Report Date Range]![Ending
>>> Date],"m/d/yy")
>>>
>>> --
>>> ProRules, LLC
>>> www.prorules.com
>>
>>
>>
>>
>>
>> "Rohn" <rohn(a)msn.com> wrote in message
>> news:eMdLCC42IHA.2524(a)TK2MSFTNGP04.phx.gbl...
>>> Is it possible to display and print the Query Parameter on a chart? I
>>> would like to have the Year and Month that the user selected displayed
>>> and printed on the chart! but can't figure out how. Here are the two
>>> query fields and the parameters.
>>>
>>> Query is: Year: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"yyyy")
>>> Parameter: Like [Type year 2006, 2007, or 2008] & "*"
>>>
>>> Query is: Month: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"mmm")
>>> Parameter: Like [Type Jan, Feb, or Mar for Month] & "*"
>>>
>>>
>>> Thanks to all of you gurus who spend time helping people like me!
>>> Rohn
>>>
>>
>>
>
>


 |  Next  |  Last
Pages: 1 2
Prev: Report with Monthly rows, Yearly columns & 3 pieces of data pe
Next: Chart based on data from report