X
x
hi
i have made a crosstab query in which row heading is "date", colum
heading is "aircraft type" and the value to be summed up is "1-10 row
totals". i want to create a simple query which should just give me the
total value of "1-10 row totals" field by defining a certain criteria.
now when i write the following in the criteria field
Between [enter start date] and [enter end date]
i get an error message saying "The microsoft jet database engine
doesn't recognize [enter start date] as a valid field or expression".
whereas the same criteria works fine when i use it in a normal query.
whats the wrong thing im doing
thanx
bye and tc
i have made a crosstab query in which row heading is "date", colum
heading is "aircraft type" and the value to be summed up is "1-10 row
totals". i want to create a simple query which should just give me the
total value of "1-10 row totals" field by defining a certain criteria.
now when i write the following in the criteria field
Between [enter start date] and [enter end date]
i get an error message saying "The microsoft jet database engine
doesn't recognize [enter start date] as a valid field or expression".
whereas the same criteria works fine when i use it in a normal query.
whats the wrong thing im doing
thanx
bye and tc