Search results

Sorry for bringing back an old post but this answered a very frustrating question for me and nobody had confirmed the solution had worked in the original thread. Final solution was very simple really. Compact and Repair worked. As soon as I had done this error no longer occoured.

You need to create a query with the Sales and Claims table linked by the policy number. You can then select which fields to show as the result of your query. The loss factor can be calculated as an expression in the query. If you are not sure how to accomplish this then have a look in the help...

Absolutely excellent. It works as desired. Thank you very much for your help. Much apriciated. :)

I think I'm even more confused now! Based on the example in the link there are a few things I don't understand. I'm sure if I could see the example I would get it but unfortnately we are not all blessed with Access 2000! A few questions. Do I need to add the criteria to the underlying query...

May help A very basic way to do this would be to ceate a copy of yourquery without the parmeter and create new form based on this query. When opened this would return all the records in the query. To search on a parameter you could have a command button that closes the form you are in and opens...

Please help. My inability to achieve this is very frustrating. I have a tabular form based on a query, which returns a large number of records. I need users to be able to filter the records to display data relating to what they have entered in a number of combo boxes. For example I have fields...