parameter query

  • Thread starter Thread starter abbas mohammad khani
  • Start date Start date
A

abbas mohammad khani

I can t use parameter query ((([ ])))) in chrt form(cross tab
query) please help me !!!!!!!!!!!
 
I can t use parameter query ((([ ])))) in chrt form(cross tab
query) please help me !!!!!!!!!!!
Click to expand...

You must use the Parameters declaration for a crosstab query. It's allowed for
any query, but it's *required* for a crosstab.

You can do it in two ways:

1. Open the query in Design view. Right mouseclick the grey background of the
tables window and select Parameters from the dropdown. Copy and paste the
exact parameter you're using from the Criteria box (or boxes) into the left
column of the Parameters window and select its datatype from the right column.

2. Open the query in SQL view. Type

PARAMETERS [Forms]![MyForm]![ControlName] DateTime;

at the start of the query, before the SELECT or TRANSFORM or any other part of
the query. Use the exact parameter that you're using and specify its datatype.


--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top