Grouping Headings in A Crosstab query

  • Thread starter Thread starter jf
  • Start date Start date
J

jf

I had checked the knowledge base on this subject but I had
a hardtime applying it to my data using the Switch
function. I am trying to group numbered identifiers. the
headings I desire are 1-8, 9-23 and 24-30. The example
used in the knowledge base uses letters. What I get is a
syntax error. This is what I wrote: Switch([TrapNo] "[1-
81-8]","1-8",[TrapNo] "[9-239-9]","9-23",[TrapNo] "[24-
3024-30]","24-30")
 
Hi,


SWITCH( TrapNo BETWEEN 1 AND 8, "1-8",
TrapNo BETWEEN 9 AND 23, "9-23",
TrapNo BETWEEN 24 AND 30, "24-30")


Your statement was not supplying conventional "conditions" .


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top