Hi everyone,
Hope you are great. I have a question that I am trying to solve since a lot of days and that I cannot find an answer in google or the forum. I have a web access database to publish on a sharepoint. I have a table with a lot of information and in the normal access database I used to make a query, make the query to prompt for an input (with [Inser data...]) and the query ran perfectly with the data that the end user used to insert there. Now my question is: how can I do this in web database. I have tried to use use parameter, basically I would like to filter according to country combinations, so I have a field which is Home Country and another that is Host Country and I put on parameters: [Insert Home Country] and then I go to the second field and I put on parameters: [Insert Host Country] and the prompt appears but no filter is applied and the countries do exist and are on the table, why it does not perform the filter? Thanks!
Hope you are great. I have a question that I am trying to solve since a lot of days and that I cannot find an answer in google or the forum. I have a web access database to publish on a sharepoint. I have a table with a lot of information and in the normal access database I used to make a query, make the query to prompt for an input (with [Inser data...]) and the query ran perfectly with the data that the end user used to insert there. Now my question is: how can I do this in web database. I have tried to use use parameter, basically I would like to filter according to country combinations, so I have a field which is Home Country and another that is Host Country and I put on parameters: [Insert Home Country] and then I go to the second field and I put on parameters: [Insert Host Country] and the prompt appears but no filter is applied and the countries do exist and are on the table, why it does not perform the filter? Thanks!
