Recent content by funkmiesterk

Hi mate Well all the first column does is takes a total of their journeys, the second total includes their home to work mileage and we have to record that info. All i need to do is get a query that just finds the highest figure from either of the 2 columns and then adds those together to get...

right because im getting totally lost i have pulled the table and query into a seperate database and have uploaded it here : http://files.ukcs.net/11308/db1.mdb if you run the query it will ask for a batching number its 0609. The totals will show Sumofmileage1 - 1447 and sumofmileageIR -...

Sorry to bump this but I didnt work over the weekend [claims]![FieldName]:IIf([claims]![Mileage1 IR]>=[claims]![Mileage1],[claims]![Mileage1 IR],[claims]![Mileage1]) entered that (added the equals too incase the numbers are the same) and it comes up with the error The expression you entered...

no success i get the following message "The expression you entered has an invalid . (dot) or ! operator or invalid parentheses." here is the formula i entered IF:IIF( [claims]![Mileage1 IR] > [claims]![Mileage1] , [claims]![Mileage1 IR] , [claims]![Mileage1] ) and it highlights the open...

ill give it a spin now. If it works ur next rounds on me! :D kev

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...

YAY i got it :) after using Brians group by SQL query. Then adding another query to count the total number. Cheers Brian I wont get a P45 as a new years present now! :D Kev

ahh i see that would make sense. Thanks for all the help mate. Hope ur hangover goes soon! mine starts tmz! :p kev

same problem its just counting each line. I only need it to count one occourence of a number ie 1234 1234 1233 1235 1234 i would like it to equal 3 but its currently equallying 5 kev

abc1234 was the example. they will actually be logged under the 4 digit code 1234 there isnt much danger of us reaching 9999 any time soon as we only ever get thru about 1200 a year and this is only going to be used for a maximum of 3 years. the field is called "batch Number - STA" cheers...

sorry im no good with access have changed the " to [] now i get a table which shows the various batch names but just has a counter of 1 next to each eg expr1 counter 1231 1 1233 1 1331 1 what i need is just the total of counter column any ideas? kev

no joy. didnt work :( below is what i typed: SELECT "batch number - sta" AS Expr1, Count(1) AS [Counter] FROM Claims GROUP BY "batch number - sta"; all i got was the same counter any ideas? kev -- edit -- SELECT [query how many claims].[CountOfBatch Number - STA] FROM [query how...

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...

worked a charm! bob- u r a legend! :cool: kev

bob thanks again for your reply but i am still having trouble creating this query. i cant seam to get the query to pull only one claimants claims. i know its hard to word ;) what i need is on record 123 is a button that actions a query that pulls any claims that 123 has submitted. but i also...