report based on crosstab

  • Thread starter Thread starter clive
  • Start date Start date
C

clive

i can't get my head round this. i have a crosstab which is
based on a query. in one field, a date field, i want to be
able to select the date before running the report.

i have tried setting up a form with unbound field. calling
the the report from this form as per previous suggestion.
it works okay with a select query.

next i add the crosstab and it fails with the error
message "does not recognise - =[Forms]![Form1]!
[Date_enter]" etc.
whats the work around please somebody.

Clive
 
You must enter the data types of all parameters with crosstab queries.
Select Query|Parameters and enter:
Forms]![Form1]![Date_enter] DateTime
 
please elaborate on what you mean ? I take it that
DateTime is what you are referring to.
where do i enter the data type?
sorry to be so thick!!!

Clive

-----Original Message-----
You must enter the data types of all parameters with crosstab queries.
Select Query|Parameters and enter:
Forms]![Form1]![Date_enter] DateTime

--
Duane Hookom
MS Access MVP
--

i can't get my head round this. i have a crosstab which is
based on a query. in one field, a date field, i want to be
able to select the date before running the report.

i have tried setting up a form with unbound field. calling
the the report from this form as per previous suggestion.
it works okay with a select query.

next i add the crosstab and it fails with the error
message "does not recognise - =[Forms]![Form1]!
[Date_enter]" etc.
whats the work around please somebody.

Clive
Click to expand...


.
Click to expand...
 
What I mean by "Select..." is to select this from your menu while in query
design view.

--
Duane Hookom
MS Access MVP


clive said:
please elaborate on what you mean ? I take it that
DateTime is what you are referring to.
where do i enter the data type?
sorry to be so thick!!!

Clive

-----Original Message-----
You must enter the data types of all parameters with crosstab queries.
Select Query|Parameters and enter:
Forms]![Form1]![Date_enter] DateTime

--
Duane Hookom
MS Access MVP
--

i can't get my head round this. i have a crosstab which is
based on a query. in one field, a date field, i want to be
able to select the date before running the report.

i have tried setting up a form with unbound field. calling
the the report from this form as per previous suggestion.
it works okay with a select query.

next i add the crosstab and it fails with the error
message "does not recognise - =[Forms]![Form1]!
[Date_enter]" etc.
whats the work around please somebody.

Clive
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top