View Single Post
  #3  
Old May 16th, 2010, 09:28 AM posted to microsoft.public.access.queries
Edwinah63
external usenet poster
 
Posts: 16
Default Flag a value in a group...

Above should read

SWITCH(fldReleaseType=0, "This is a 0", fldReleaseType=1, "This is a
1", fldReleaseType=2, "This is a 2") AS MyCalculatedField