Search results

Hi everyone. What I currently have is 2 columns in one table 1 is required and 1 isnt. However what i need to do is work out the sum value of the greater amount from each line. IE A B 1 2 1 0 2 1 which would give a total of 5 as its adding B1+A2+A3 I tried creating a 3rd columb and...

Hi everyone. I have a pretty basic database with about 8 tables linked together. The database is going to be used for keeping an electronic record of claims for upto 5000 people. I have been asked though to have box on the menu screen which shows both the number of claims and the number of...

Hi there, What i've currently got is a database with 3 tables 1 will be used to store records of upto 6000 claimants with various bits of info another 1 will be used to store claims from these claimants (at least 12 per calendar year per person) and 1 will be used for queries. the problem i...