D
Dick Minter
My report query includes a link to and fields from a crosstab query. The
problem is that the field names produced by the crosstab may change from time
to time. My solution was to place code to determine the fieldnames, modify a
string SQL statement, and run the modified statement using "docmd.runSQL."
Not only has that not worked, I find that the SQL statement produced by
interactive Access also won't run using docmd.runSQL (syntax error cited).
DM
problem is that the field names produced by the crosstab may change from time
to time. My solution was to place code to determine the fieldnames, modify a
string SQL statement, and run the modified statement using "docmd.runSQL."
Not only has that not worked, I find that the SQL statement produced by
interactive Access also won't run using docmd.runSQL (syntax error cited).
DM