Search results

ok, i have a database that consists several forms and i want to export selected variables from each of the forms. ultimately i want the data to be in SPSS but don't know if it can be exported directly to SPSS. what is the easiest way to do this? i am an access novice so am not sure whether i...

i have several number fields that contain reaction times. i want them to be decimals, for ex. 4.55, etc. for some reason they are all rounding up (i didn't add any roundup function). i have tried all kinds of things in the properties box but nothing seems to work. any suggestions?

the thing is, i still want it to use that id, for example, i just want it to drop 99 from the calculation. but not necessarily drop the entire id if 99 is found anywhere in their data. i don't know if there is an easy answer to this problem. thanks.

i have several calculations in my queries that include several variables. each of these variables has a potential to be scored as a 1, 0 or 99. a 99 is a missing value and i want to exclude it in my calculation. any ideas? will criteria just limit my total in the calc. as opposed to limiting the...

it appears as though the function Median=(table name)(field name) will work. but in my case, i am using several variables on my form. for ex. Median=(var1,var2,var3,etc). does anyone know if this formula will work, how do i separate the variables? thanks. Angela

does anyone know how to calculate a median in a query. is it the mid function? thanks for the help.

i am not sure how you create a public function? can you be more explicit. when i try to run the query i am doing, i get a request for a parameter value? thanks

I have several forms that we are interested in getting totals, avgs, etc. for some of the variables. these forms represents tasks that kids are doing. for ex. on one form i would like to calculate a total inconsistent score. i know how to write the calc. -- my ? involves the logistics of the...

I have several calculations which i have built into my form. Everything is working on the form, the calc. are coming out correctly but when i run a query with the variable i created the calcution in, nothing is showing up. why is this?? the calcuation doesn't show up in my table either, only on...

I have several calculations which i have built into my form. Everything is working on the form, the calc. are coming out correctly but when i run a query with the variable i created the calcution in, nothing is showing up. why is this?? the calcuation doesn't show up in my table either, only...

i have several calculations that are being done on a form. i made each calculation a variable in my table beforehand. For example cs_avg. Then when designing my form, i dragged the var. cs_avg over to the form as a basic text box. used properties, control source, where i used the expression...

i have 14 separate forms-- data will be entered so that all 14 forms for id #1, then all for id#2, etc. therefore, i have added a command button at the bottom of each form, linking it to the next form. i used the wizard and linked the id's (so that if you are on #7, clicking the command will...

i have a form that contains 5 questionnaire items (presented with drop down boxes). each question has a right answer (1), a wrong answer (0) and the option of refused (99). i want to calculate the total trials completed, in other words, count up how many trials the individual completed with...