Two fields combined

[deb]

I have a table called tProjectDetails it has 2 fields called FT and RD which
are checkboxes.

The table data looks like this...
ProjectID Unit FT RD
1 1 -1 -1
2 1 -1
2 2 -1 -1

How can I make the query look like this... for charting purposes

ProjectID Unit FTRD
1 1 FT
1 1 RD
2 1 FT
2 2 FT
2 2 RD

Thanks in advance

 

[John Spencer]

You could use a union query

SELECT ProjectID, Unit, "FT" as FTRD
FROM tProjectDetails
WHERE FT = True
UNION ALL
SELECT ProjectID, Unit, "RD" as FTRD
FROM tProjectDetails
WHERE RD = True

Open a new query
Don't add any tables
Switch to SQL view
Paste the above and see if it works

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[deb]

Works perfectly. thank you