Is there a way to use Extract(from ) in the query designer, cause if you do the SQL by hand it doesn't work with the crosstab, it doesn't recognize the values
Yes, this is possible, using the "Calcs" tab of the query designer. Simply double click a field to bring it down to the Calculations window. Change the "Function" property to Expression. Assign a new Field Alias. Finally insert your expression in the "Expression" field. Something like EXTRACT(Month FROM SaleDate).
Comments
Yes, this is possible, using the "Calcs" tab of the query designer. Simply
double click a field to bring it down to the Calculations window. Change
the "Function" property to Expression. Assign a new Field Alias. Finally
insert your expression in the "Expression" field. Something like
EXTRACT(Month FROM SaleDate).
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com