B
BusyProfessorFromBremen
Dear Everybody,
I experinece dificulties by applying a crosstab function on a query. Once I
've copied the content into another table I can handle a Cross Tab function
but on the other hand the linkage to its source got lost.
Hence it would either be ideal if I could attach the content of the query to
a linked table or by modifying the statement running it on the query itself.
State of the art:
Tranform First(table1.[Field1]) as TheValue
Select [ID]
From Table1
Pivot ("Field1") & RANK;
Translated error message:
The Microsoft Office Access Database modul can neither identify
'table1.field1' as a field entry nor as an expression.
Any support is greatly appreciated.
Tank you very much in advance!
malte
I experinece dificulties by applying a crosstab function on a query. Once I
've copied the content into another table I can handle a Cross Tab function
but on the other hand the linkage to its source got lost.
Hence it would either be ideal if I could attach the content of the query to
a linked table or by modifying the statement running it on the query itself.
State of the art:
Tranform First(table1.[Field1]) as TheValue
Select [ID]
From Table1
Pivot ("Field1") & RANK;
Translated error message:
The Microsoft Office Access Database modul can neither identify
'table1.field1' as a field entry nor as an expression.
Any support is greatly appreciated.
Tank you very much in advance!
malte