K
Kevin
Hello
I am finding myself writing increasingly lengthy queries
in SQL view to create queries to summarize table data
e.g.CalcIfTrue: ((IIF [Field] = True,1,0))
SUM_True = Sum(CalcIfTrue)
Is there a character that I can use to have Access regard
a line as a comment? It's getting to the stage where I'm
needing to start annotating the SQL!
TIA
Kevin
I am finding myself writing increasingly lengthy queries
in SQL view to create queries to summarize table data
e.g.CalcIfTrue: ((IIF [Field] = True,1,0))
SUM_True = Sum(CalcIfTrue)
Is there a character that I can use to have Access regard
a line as a comment? It's getting to the stage where I'm
needing to start annotating the SQL!
TIA
Kevin