Search results

I hope someone will be available to help me (please see attached zipped database). I posted the same question under the table section but they told me the problem is in the form design. My simplified database is attached I exported a list of names from excel file to my tblNames. On my 'main'...

I hope someone will be available to help me (please see attached image). I am not sure if I laid this out properly. My main form has a listbox with names (which I exported from excel spreadsheet into tblNames) and by clicking on individual name I can select from (so far) 3 forms ( custom...

Hello, in my form I have two fields: date booked (surgery) and wait time. I would like my wait time field to caculate days someone is waiting for surgery based on date booked and today? Many thanks, Debbie

I have a webform (it is designed the way that administrator can add questions on line), but this form doesn't have any setting for date (date validation). So, in my access database I added a new question category called OPEN4 which I would like to use for dates. I am attaching the whole page...

I have a make-table query and I was thinking if there is a way to update this table when changes occur automatically? Many thanks, Debbie

Hello, I am attaching my database as I gave up on my smartness. I have the following problem. There is online form for patients. Few times a year they are obligated to fill in the form so we can follow up on their progress. Each patient has unique medicalrecordid and every time they do the...

Hello, I have some problems with report I have to build. We have on line form and patient fill it in and submit it a few times a year. So each submission has unique response id. On my access form a have a list box with patient name, response id and medical record id. Medical record is unique...

Patient, with unque PatientID, can submit several surveys to our database (each survery has unique response id). How can I build one report per unique patientid (to see all reports he/she submitted in one report)

Hello, On my main form I have a list box with our patient names and IDs. Some patients are entered a few times (but they have same patient record number). What I am trying to do is to have a list showing patient name only once and in report (which is accessible from this form) to show all...

Hello, My data is coming to my access database from my webform but I would like to have an option for some fields to be altered/changed/added from my access form. So how can I refer to a field in my table? questionID is the field name but in my access form I would like to have several subfields...

I have one more question. I want use count function but to count records from several fields =CDbl(Nz(Count([firstfield],[secondfield),0)). Where field is zero not to count it in. This function is working when I have only one field but when I add second I get an error message. Many thanks for...

Hello, I am trying to do a simple calculation in my report: = sum ([a] + [b] + [c] + [d] + [e]) but I keep getting an error message. This report is based on the crosstab query and these fields a,b,c... are text fields. I would greatly appreciate any suggestions. Many thanks, Deb

Hello, I created a crosstab query and I would like to add this criteria to it: [Forms]![Main]![ID] but I am getting Microsoft Jet Database message that this is invalid criteria. IIt works when I test it in regular query. Can please someone tell me what I am doing wrong and is there any way...

Hello, I would like to show records in my query only if records in raw a and b are equal and they have same question id. Please let me know if you can help. Many thanks, Debbie

I have a questionnaire webform that send data to my access database. In my database I have a few tables: Users (FullName, age, date, medical record), table Questions (stores question number, question answer, iduser) and table results (stores predefined scores for each question/number and...

I have a questionnaire webform that send data to my access database. In my database I have a few tables: Users (FullName, age, date, medical record), table Questions (stores question number, question answer, iduser) and table results (stores predefined scores for each question/number and...

Hello, I already tried everything I know (I don’t know much though), and I already checked with table and query discussions but wasn’t able to resolve my problem. I have access database and asp web form (on line questionnaire). I set up everything properly (I think) except I can’t attach...

Hello, I was hoping someone can help me how to put the following statement in right format. I have 4 fields idResult, QuestionNumber, Description and Result. So If Question Number and Description have same idResult then Result is (results are defined in the table) there are 30 combinations...

Hello, My brain is currently not working and I am hoping for somebody’s help.. I have an access database that collects medical survey info (data is coming from the online form). I have 3 tables: Tblquestions Tblpeople Tblanswers There are 30 questions and each question has mostly 5 choices...

I have a field in access database called result (coming from webform) and the content is something like: 'not much; 2' or 'frequently; 5'. How can I split numeric and text value into two separate columns in query? I will greatly appreciate any help. Debbie