I have a query which pulls from a crosstab. I am trying to determine how to reference one of the cross tab columns by using data supplied from a form/ I tried referencing the form field, i.e ftecrosstab.[forms]![teach
] and that returned an error - not recognized as a valid fieldname Here is the SQL
SELECT ftecrosstab.trschool_id, ([2015-2016])-([2014-2015]) AS [+/-], schools.schoollName, schools.Type, ftecrosstab.[2013-2014], ftecrosstab.[2014-2015]
FROM schools INNER JOIN ftecrosstab ON schools.school_id = ftecrosstab.trschool_id;
How do I reference ftecrosstab.[2013-2014] which is a column in a crosstab query by using a reference to a form that pulls the date? I also need to subtract those two values are part of the current query. The query above works with me supplying the dates as written. Thanks.