Search results

ok i got it to count the right total but there is a slight problem now when it is a even amount say say like 79/8=9.8 so that would be 10 samples but now if i add the .9 it will make it 11 which is now 1 more or another example would be 40/8=6 which is the correct amount of samples but in the...

they why is the expression in my report coming out to be 6 instead of 5 the expression that i use in the product footer is =sum([producttotal]) and it seem to count it but it goes to 6 i added the numbers up as if they where +.9 and it comes out to 5.6 which rounds up to 6 but it actually is...

well originally that is the way i had it but the problem with that is it off by one in the total count. let say i got counts of 3,2,1,1,2 so that would be 3/8+.9=1.275 2/8+.9=1.15 1/8+.9=1.025 1/8+.9=1.025...

firs here is the expression that i am using producttotal: ([CountOfProduct])/8 ex:count of product is =6 so then it would be 6/8=.75 but it actually is 1 sample so i i need it to round up but then i also have some that are like count of product is =19 so then it would be 19/8=2.375 which is...

still can get this database to count the total for me. i have tried all the sugestion from my last thread but none of them work. it counts for me in my Lot header in my report just fine here is the expression =Int((Count([product])/8)+0.9) it counts that fine and give me a answer but now i want...

yes the original expression works, it calculates but when i try to get it to count on the footer the total it won't

still have no luck tried all kinds of stuff anyone else god idea on how i can get this total think to work

tried that and it comes up with a error that sayss cannot have aggregate function in expression But thanks for the help, anyone else

first of let me say hi to everyone, it my first time here so i am n00b, so dont get mad if i ask a dumb question u got to bare with me. well here it goes. i have a equation in my report that is written like this =Int((Count([product])/4)+0.9) what it doesn is it counts the total sample and...

well i was hoping for a simpler solution. i do notice on windows 2000 there is limit to the amount of user connected to a shared folder 10 to be exact. could that be the reason why since only ten people log on to the same shared folder cause they way we have it set up is the main database is on...

we have a database at work that is being runned on a server machine running windows 2000, the problem that we have is we have 11 machines that connect to the database on the windows 2000 machine. when we get to the 12 user it says to many connections open, so now one of the computers have to log...