Search results

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...

Many thanks, I don't know what I would do without Access Programmers Forum. Deb

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...

I know I made it sounds too confusing and I know that names are not actually very descriptive (as it started as test project (I will changes names) . So for example. I am a patient and I will be directed to fill in this questionnaire in the waiting room. So I will have to answer 30 questions...

I just tried: multiple scores for multiple questions (solved with a juntion table called QuestionScores with ID (PK), ScoreID (FK), QuestionID(FK), and potentially other defining fields) but it doesn't record IDs. Maybe It is something wrong with my webform structure: This is what I am doing...

Basicly I want to be able to pull out reports by name and calculate their scoring.

Some light in my life :-) I am attaching my DB. Please check tblResults. You will notice that scoring is different based on two criteria (description and Question Number). So in my query I can’t get scores showed related to each record (so it should be a name, question number, description...

ps, I tried adding questionid to my score table but it doesn't feed in from my webform

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...

Many thanks for your reply. I followed your instructions and replicated your code into: select Questions.QuestionNumber, Questions.QuestionAnswer, tblResult.IDResultO, tblResult.Results from Questions, tblResult but I got over 4000 records instead of 31. I have a webform that feeds in this...

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...

I would greatly appreciate anybody's reply. I am under a deadline and I tried everything I know. Many thanks, Deb

Hello, I just browsed through the answers but couldn't relate my problem. I have a web based form and I am just receiving answer into my database. I need to have a scoring table that can relate to each answer. What I did, and it is wrong, I put together answer and score (same field) and then...

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...

Works perfectly, THANK YOU VERY MUCH. Deb

Thank you for your reply. I am attaching a database. The data is coming from the web based form. The query that I am having problem with is called 'User Query'. It is a web based medical survey and I am just trying to attach certain points to each answer. I wanted to create a separate table...

Still same error message. PLEASE HELP> Deb

Still doesn't work. In each emty field I get #Error