Search results

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

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

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

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

Folks I use access 2007 and I need to produce a total for fields where several fields answers include ranges and could be the same ie: answer could be 0-25,26-50 etc and within the column the 0-25 answer may appear 3or4 times. I thought in a query using the total row in the criteria grid but I...

Hello Folks I need to trim values in field that has the following type of format 0001.01,0001.02. Apparently there is a way of doing it by using the Microsoft Access RIGHT function based on the length(LEN) of each string. Can anyone explain how this Microsoft Access RIGHT function works and how...

Folks Below is an sql query in access 2007 that i'm trying to use to bring up any grantor and grantee field that involved the willmot family but its producing a big fat zero. Can anyone offer a tip what I'm doing wrong: SELECT Property.ID, Property.StNum, Property.StName, TitleSearch.ID...

Hi Folks I use access 2007 and for a data base, I have the following field names: id number, current use, original use. I need to run a query that will only show id numbers where the original use is different from the current use. All 3 fields are in the same table. Regardless, what I try my...

Hello Everyone I use access 2007 and need to run query that extracts data from a field which has 10 digits(numbers) in it but the first digits(numbers) mean something different from the next 2 digits(numbers). Does anyone how to run a query that would extract those 4 digits(numbers) from the...

Hello Everyone This is my first post. I have Microsoft access 2007. As required, I have downloaded an access database that is in form view and I need to do queries on this database to extract specific data. I feel comfortable attempting the queries only if I can see the data in the database via...