Search results

im tring to do your calculation but its giving me an overflow error??? maybe i eft out some info.... i have a table with data in it as follows....the first for lines Name TimeLoggedIn Numberoflines RonanC 00:35 300 RonanC 00:55...

O.k...my first result,,, Name:ronan, Total_Time:1.5, Total_Lines:346, Lines_per_minute:0.13****** The lines_per_minute should result to 8.65 witch is the result of ((1.5 / 60) * 346).... I hope you can figure this out Thanks for the quick reply

Hi All...im trying to setup a query in ms access but its realy starting to bug me...ill try and explain as good as possible... i have 3 fields, 'Name', 'time_logged_in' and 'lines_per_day' i need to get the number of lines people do per minute...so this is my query 1 and a half hours would be...