Solved
Access 2007 SQL Query
Posted on 2013-02-04
Hi,
I've got a little query on a query.
I have 1 big table, there is 1 field which is [text](key field) the rest are [yes/no]
Acc Number [text]
Electrician [yes/no]
plumber [yes/no]
Joinery [yes/no]
.... lots and lots more
Basically I have this table of trades and I want the query to make their trades into Strings.
So if Acc number "1" is ticked for electrician and joinery, the query results will display, "electrician joinery" etc etc
Currently I'm doing this with 100's of IIF statements, Electrician2:iff([electrician]=yes,"Electrician","") then doing a concat of all of these results.
This works but takes ages and I'm sure there is a ...more intelligent efficient way to do what I'm trying to achieve :)
Any help appreciated.
Rich