Search results

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

lol no i mean it will be used for logging queries we receive ie claim being late etc. ok the info logged in the claimants table is claimant number name budget code and other non important info (drop down boxes for future reference) the info logged in the claims table is claimant number...

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