Search results for query: *

perfect, the program you directed me to has shown me how i incorrectly arranged my data and I can now pull the information I need. Thank you.

The total row cannot be toggled off in a crosstab query. I am not looking for the total row and have no use in it. I know that I can use Union to add a query to a query vertically and am looking for something like this but horizontally. Current Data: Person A Yes Person A NO Person B...

I think this is transposing in access.

Hi all, Pre-thanks for reading this. I am in the process of reporting data based on surveys that have been conducted. I have a hand full of different tables (Survey, questions, answers, contacts, surveylink (Contacts & surveys to answers)). I would like to display the survey results on a...

Never mind, i got it.. just have to put 'How many employees'

The code above works perfect but how would I input 'VALUES' with spaces in them. if i want sqlSelect to be = "How many employees" it gives me a runtime error '3075' - Syntax error (missing operator) in query expression 'How many employees'. I know that refers to the lack of spacing so is there...

Sorry about being unclear Currently my table appears like: Table: Actual ___________________________ Q1 Q2 Q3 Pop.? Staff #? Tier? -------------------------- I want it to appear like: Table: Desired __________________________ Q1 Q2...

Im trying to get what your saying but the code doesnt lik eme.. grr On another note, I am trying to populate the table with some information from another coloumn. This information is the actual text to the corresponding Questions. Using the following code: For i = 0 To count - 1 Step 1...

if i use the currentdb.execute command it will populate the field from the last recently filled table example, populating city with 1 2 3 4 5 6 City Q1 Q2 Q3 1 2 3 4 5 6 I want to leave a field blank sot hat it would be City Q1 Q2 Q3 1 2 __ <-- blank 3 4 5 6

Do you happen to know how to skip a field?

I currently have this problem. I've read that this problem may be caused if you have a welcome screen enabled. Try to change it to prompt or tunr it off

Money in the bank. Thank you so much. I used CurrentDb.Execute "INSERT INTO tempTable(Field1) SELECT questionID FROM question WHERE surveyID = 3" It immediatly populates the field, so works really well

Hi So I am trying to populate a temporary table in the same form I created it. I create a temporary table based on a survey the user summited. I want to populate that table with questions. It would look like: Municipality Question3 Question5 Question 19 Population...

oh ho! works perfect. thank you!

Hey, first post here, and I'm new to access I'm trying to set up a form regarding survey completed by different cities. Relationships: Survey's have one to many to questions (linked by surveyID) Survey and Cities are linked through SurveyLink that has SurveyID, CitiesID, SurveyLinkID. What...