SQL MS ACCESS: Split row into multiple based on column value

1 vote

1 answer

1371 views

ms-access ms-access-2010

                          I have table (SQL MS ACCESS)

    COUNTRY   NO_OF_PAGES
    FRANCE    2 
    UK        4
    GERMANY   1

I want output

    COUNTRY   NO_OF_PAGES
    FRANCE    1
    FRANCE    2
    UK        1
    UK        2
    UK        3
    UK        4
    GERMANY   1

 
                        

Asked by user143760 (11 rep)

Feb 1, 2018, 07:09 AM
Last activity: Jul 9, 2018, 07:59 PM

SQL MS ACCESS: Split row into multiple based on column value

Related Questions