Search results

Your right, it does sound pretty similar to my problem. In my experience, using a switch statement is one way of solving it. Im not entirely sure if you should put the code in your querie or in the SQL code behind your combo box (id imagine the latter, if this is the case you will have to...

Hiya Im still having difficulties querying a query depending on the value selected. Ive done a bit of experimenting. The sample program consists of a table, querie and a form. In the table i have one field with several page sizes in it e.g "5*4", "A4" etc. The query is based on the one...

I ve managed to solve this problem. I couldnt seem to get it to work with any of the suggestions (possibly because the code is not compatible with the Sql statement behind the query which is where i placed the code). Instead, in the SQL i used a Switch statement as follows SELECT...

I did not explain properly I have a table which has a list of countries, and another with details of which hotels within these countries have paid money (e.g amount paid). I have grouped this table so that i have a list of countries which have paid money. I then created a query with both...

I have a table which has a list of countries, and another with details of which hotels within these countries have paid money. I have grouped this table so that i have a list of countries which have paid money. I then created a query with both tables, which have a relationship based on...