If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart Object with SQL Query
I have an Access form with an embedded chart object which originally acquired
its data from an Access query. Start and End date parameters were passed from the main form to the underlying Access query and the output data passed to the chart Now the query is an SQL Server query and I do not know how to pass the date parameters to the SQL query. I can pick up the column data in the SQL query so the chart is produced but using ALL data in the underlying table rather than between start and end dates. Does anyone have a solution for this? Help appreciated Regards Pete |
#2
|
|||
|
|||
Chart Object with SQL Query
Your issue is in the SQL Server domain, not Access.
HTH -- -Larry- -- "PeteVTX" wrote in message ... I have an Access form with an embedded chart object which originally acquired its data from an Access query. Start and End date parameters were passed from the main form to the underlying Access query and the output data passed to the chart Now the query is an SQL Server query and I do not know how to pass the date parameters to the SQL query. I can pick up the column data in the SQL query so the chart is produced but using ALL data in the underlying table rather than between start and end dates. Does anyone have a solution for this? Help appreciated Regards Pete |
#3
|
|||
|
|||
Chart Object with SQL Query
Larry,
Thanks for this but are you able to be any more specific? Regards Pete "Larry Daugherty" wrote: Your issue is in the SQL Server domain, not Access. HTH -- -Larry- -- "PeteVTX" wrote in message ... I have an Access form with an embedded chart object which originally acquired its data from an Access query. Start and End date parameters were passed from the main form to the underlying Access query and the output data passed to the chart Now the query is an SQL Server query and I do not know how to pass the date parameters to the SQL query. I can pick up the column data in the SQL query so the chart is produced but using ALL data in the underlying table rather than between start and end dates. Does anyone have a solution for this? Help appreciated Regards Pete |
#4
|
|||
|
|||
Chart Object with SQL Query
For pass through queries, you need to know what the target application
requires. That information is more likely to be found in the target application's Help files or in Newsgroups that support it than here in a newsgroup devoted to Access. HTH -- -Larry- -- "PeteVTX" wrote in message ... Larry, Thanks for this but are you able to be any more specific? Regards Pete "Larry Daugherty" wrote: Your issue is in the SQL Server domain, not Access. HTH -- -Larry- -- "PeteVTX" wrote in message ... I have an Access form with an embedded chart object which originally acquired its data from an Access query. Start and End date parameters were passed from the main form to the underlying Access query and the output data passed to the chart Now the query is an SQL Server query and I do not know how to pass the date parameters to the SQL query. I can pick up the column data in the SQL query so the chart is produced but using ALL data in the underlying table rather than between start and end dates. Does anyone have a solution for this? Help appreciated Regards Pete |
Thread Tools | |
Display Modes | |
|
|