Search results

sorry i misunderstood what you meant but luckily i was playing round with a few options and i think i figured it out, thanks so much for your help everyone it is much appreciated.

OK i have attached some random data showing whats been happening with my actual data, so for question 1 i have to have put in a report all the peoples names and the avg,min,max hours but as you can see in question 1 report it works it out for all of them, for question 2 i have to make a report...

OK ive got all the formulas working, thanks for all of your help, i just have a few more questions: 1. i need to make a report that calculates the min,max,average hours of attendance but when i go through the report wizard it does a separate min,avg,max calculation for every entry but i need...

ok i found it but it is still rounding it up so if i put in 8.20 it rounds it to 8.00 how do i turn off rounding?

where can i find the field properties i have right-clicked the highlighted field but that option isn't there

i have one quick question i want to write in numbers with a decimal place but when i write in 9.25 it shows up as 9 where can i change this so it shows numbers after the decimal place? i have tried the decimal forward button but it just adds 0's after my number instead of the .25 i put in.

i thought it was weird too, when i downloaded it said MDB but the file appears as a PhP on my desktop. EDIT: just got it working will take a better look tomorrow. thanks for your help.

what program opens this type of file? i have never opened a php file so i need to associate it with a program

where is the sample database sorry i cant find it

so how can i use this function in a query? where/when do i enter the TimeFHNS formula in the query?

i cant get it to work i have tried it it a calculated column but it says timeFHNS cant be used there so i tried it in number, text, time and date columns but still nothing, i have changed the "first time/second time" things to my field names an everything else was written the same as in your...

does this work for difference between times as well? and what type of field do i use it in e.g. calculated, time/date, number etc

ok i just want to make sure so when i entered that data into the module i didn't have to name it anything right? because i left it as module1. also could you please be a bit more specific about the next step because i don't know what you mean by unbound text box, in its control source and change...

OK so i open my database, i press alt+F11 then i go insert module, i copy in raskew's text then what do i do?

so where do i copy it to?

im sorry like i said im really new to this program, could you be really specific as i don't know the names of all the feature of access yet. why does it require such large formulas to calculate something that should be really simple?

i have tried a few of the suggestions (the ones i understood, ive been using this program for a total of three days) i have got it to display as 8:15 which is the format i want but if you click into the field it shows up as a time e.g. 8:15:00AM, all i need is to find the difference between one...

how do you use the format function? where would i put it in this function [end time]-[start time]

do you mean what comes up when i enter the formula?

i have looked all through help, ive Googled all my questions and have even tried you-tube but everything i try either the answer is wrong or the format is incorrect that is why i have joined this forum because im stuck :(