Pipes in MS-Access sql (1 Viewer)

lawman

New member
Local time
Today, 10:18
Joined
Dec 8, 2020
Messages
15
Does MS-Access allow usage of pipes in sql query? eg. ¦¦



I have a query below suggested for sqlite using pipes.
When I try to use it in MS-Access, I get an error because of the pipes.
What should I replace that with to make this query work?

Code:
select t.students, c.name class, t.students_count
from (select sc.idc, min(s.name) || case when count(*)>1 then ' +' else '' end students, count(*) students_count from student s inner join studentclassjoin sc on (s.id=sc.ids) group by sc.idc) t
inner join class c on (t.idc=c.id)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:18
Joined
May 7, 2009
Messages
19,169
its a Concatenation symbol.
in Access, "&"

... min(s.name) & IIF( count(*) > 1, " + ", "") As students, ...
 

Users who are viewing this thread

Top Bottom