Search results

Mr.B Tks for your help. I will redownload the adjusted database asap and relook at it. Sorry, one further question: As you notice in my db, my survey responses had fields with multi-field values ie: education, income. If I wanted to get an average or the medina of the income level...

I have attached my database called survey. I have 3 different but I think related problems. First, when opening the survey questions table an"Enter Parameter Value" box appears, asking for Survey responses.Respondent ID. Respondent ID was that was deleted as I thought it was not...

tks mykil, will try that.

Hello Using access 2007, I have a table with responses from a survey in various fields(columns) and I want to use a combo box to add up the rows. I've looked and most combo boxes refer to using a form not a table. How would I use a combo box to extract the rows data from a table? Tks fllopez65

tks apr pillai,will try your suggestions.

Hello I've had to import some excel spreadsheets into access. The columns in the spreadsheets are very long ie: Total population of females with postsecondary qualifications by major field of study - 20% Sample Data. Invariably, these titles are being truncated or in some cases access doesn't...

Tks vbaInet, will try your suggestions.

VbaInet I was under the impression I had to fix the column before importing the whole spreadsheet into access. The spreadsheets with these "problem" columns are very large. Are you saving import this excel spreadsheet into access the way it is then fix it in access? Could explain a little...

Hello I've converted an ivt file to excel and need to trim some values(drop some zeros) in a column before exporting to access. The cells in my column look like: 0001.01, I need 1.01 0001.02, I need 1.02 0017.01, I need 17.02 0220.01, I need 220.01 Assuming 0001.01 was cell A2. I believe...

Tks will try using the .values and expression to get my totals.

Using the .value does seperate the rows but doesn't give the totals I need though but tks anyway.

vbaInet found the .value. tks fllopez65

I'm not sure what you mean by .Value? I will try the expression instead. tks

But the household income was a multi-value field also. why does it allow one and not the other?

I modified the sql statement to read:SELECT [Survey Responses].[Buyers age], Count([Survey Responses].[Respondent ID]) AS Total FROM [Survey Responses] GROUP BY [Survey Responses].[Buyers age]; but I keep getting an error message: The multi valued field: '[Survey Responses].[Buyers age] cannot...

Tks to both vbaInet,plog, got it to work and will modify as necessary. fllopez65

Tks vbaInet,plog will try your suggestions. fllopez65

vbaInet I previously attached is my database which has a questionnaire and a data of sample responses. What I'm trying to do is to design a query which would provide(using household income as an example): a. Totals for a particular range, for example: 0-25,00 b. An average for that same...

Tks will try the suggestions. Will it work for the attached db?

Plog Will try asap. tks fllopez65