none
Access 2013 web app query returns all data colums, but not the selected ones. RRS feed

  • Question

  • Created a simple query.  Select c_Naam_Voornaam, C_Naam,C_CliëntNummer From tbCliënten 


    Expected resultset as with values for the selected columns.  I receive no data in the selected columns and received all columns of the table with data.


    I noticed a similar behaviour when doing a left join query.  It will give notheing for the selected colums and all data of the table of the 1st field in the join query. 

    Thursday, November 6, 2014 2:18 PM

All replies

  • Hi webaccess,

    Base on my test with Access 2013, it works fine.

    Please follow up these steps below to check it:

    Please follow up these steps below to check it:

    1. Create a new Query and select some fields.
    2. Create a new View by using that query as datasource.
    3. Check whether it adds the corresponding controls for the selected fields.

    Best Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, November 7, 2014 10:04 AM
    Moderator