How to concatenate multiple select queries

[usumban]

Hi,

I have a table as given in the sample below. I should be able to select records that have reviews in May-2013 with project type = XX (desired result given below). How can this be done? I am fairly new to Access. Can anyone please help me with the query to accomplish this? Many Thanks.

--usumban

[Rabbit]

As a rule of thumb, I don't open attachments from strangers. Please post all relevant information in the thread itself.

But if you want to combine the results of multiple queries, you can use a union or union all.

[usumban]

Please see below for more info. Thanks.

ProjectName    ProjectType    Review1    Review2    Review3    Review4    Review5
GGGG    XX    Oct-2012    Mar-2013    May-2013    Nov-2013    Apr-2014
FFFF    YY    May-2013    Jul-2013    Dec-2013    Feb-2014    Jun-2014
AAAA    ZZ    Jun-2012    Jan-2013    May-2013    Aug-2013    Feb-2014
BBBB    XX    Feb-2012    Oct-2012    Mar-2013    May-2013    Jun-2014
TTTT    XX    Jul-2012    May-2013    Nov-2013    Jan-2014    Jul-2014
CCCC    XX    Feb-2011    Dec-2011    May-2012    Dec-2012    May-2013
DDDD    XX    May-2013    Sep-2013    Mar-2014    Aug-2014    Jan-2015
 
Desired Result                        
ProjectName    ProjectType    Review1    Review2    Review3    Review4    Review5
GGGG    XX            May-2013        
BBBB    XX                May-2013    
TTTT    XX        May-2013            
CCCC    XX                    May-2013
DDDD    XX    May-2013                
 
        or                 
    ProjectName    Project Type                
Review1    DDDD    XX                
Review2    TTTT    XX                
Review3    GGGG    XX                
Review4    BBBB    XX                
Review5    CCCC    XX                
 

[Rabbit]

The problem is that your data is not normalized, that makes it more difficult to create queries. We have an article about normalization here: http://bytes.com/topic/access/insigh...ble-structures

[usumban]

Thank you, Rabbit for the quick response. I imported this data from an Excel spreadsheet that has 36 columns related to projects and 100s of records. So, is it possible in Access to create tables with table1 having project names, types and other related field and another table (table2) for review dates and then import the data from excel into those particular tables(i.e) the project name, type etc data to table1 and review dates into table 2? Like I said before I am new to Access and learning it. Thank you for your patience and would appreciate your guidance in creating the database.

Thanks,
Usumban

[Rabbit]

In a situation where data comes to you unnormalized, you can create a series of queries to normalize the data. What those queries would be depends on how you design your tables. In your case, I think you're right, you would only need two tables. One for project and one for review. Then you just need two queries to insert the right data into each.