thanks for replying. i would be happy to send the information in an e-mail! i have lots of yes/no data in the table. i created the form using the wizard and pulled over all the information, then a message just appeared that same the form could not be created. that is why i was wondering if...
Trouble With My Form! This is my problem, I created my table, then created my form or tried to, but I got a message that my form could not be created but yet all my information was there. I continued to work on the form, arranging, etc., and everything looked great but when I tried to preview...
Trouble With Form! Pleae help! After I created my table, then went to the form to create in it design view. I pulled alll my information over, but I got a message that my form could not be created but yet all my information was there. I went ahead and worked on the form, arranging, etc., and...
my expression is in the report footer. i am so confused and new to all this. i have a textbox for the dcount in the detail section of my report (which is not visible) and this does work. i added 2 more records and this number changed from 4 to 6.
i was told yesterday that i could just use...
hello paul, i hope you are still there. my dcount is working but my division is not! this is what i have in a textbox for the control source.
=DCount("[ertimebeforeseen]","emergencyroom query","ertimebeforeseen]")/Avg([ertimebeforeseen])
thanks!
well, paul, guess what - i am having trouble. i will get back tomorrow - too tired tonight. my e-mail is lrdutches@aol.com if you would rather help me figure this out through e-mail, that's fine. can a file be attached in this forum?
i have the dcount working for a field. now i need to take the dcount and divide this by the average that i have calculate for this field. how do i write this? my dcount answer is 4 and my average count is 2 so therefore the answer i am looking for is 2. i did the =(4/2) and i get the answer...
ok - i have the dcount working for a field. now i need to take the dcount and divide this by the average that i have calculate for this field. how do i write this? my dcount answer is 4 and my average count is 2 so therefore the answer i am looking for is 2. i did the =(4/2) and i get the...
i need to get a simple total using the dcount and my mind has gone blank! i am pulling information by date and i need a total number count of how many responses that i had for a survey question for the date that i am pulling. this is what i tried but is not working...
hi barry - my formula is "kinda" working! ha! i have the survey set up in a form where the receptionist will enter all the data when a survey is turned in. One of the questions is "Waiting Time Before Being Seen By A Nurse" and there is a drop down box for her to click the...
i have the survey set up in a form where the receptionist will enter all the data when a survey is turned in. One of the questions is "Waiting Time Before Being Seen By A Nurse" and there is a drop down box for her to click the number that was circle (1,2,3,4,5). Then she can pull a...
Duane
I just realized what part of my problem is but not sure how to correct it! I am actually getting the correct number in my report BUT the correct figure is pulling only one record from my form. I need the total for my question that is in my form and then from this I need it to pull...
I am working on a survey with the rankings as 1 - with an assigned value of 0, 2 with an assigned value of 25, 3 - with an assigned value of 50, 4 - with an assgined value of 75 and 5 - with an assigned value of 100. when i bring this over into my report from the query, i get the right answer of...
I am working on a survey with the rankings as 1 - with an assigned value of 0, 2 with an assigned value of 25, 3 - with an assigned value of 50, 4 - with an assgined value of 75 and 5 - with an assigned value of 100. when i bring this over into my report from the query, i get the right answer of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.