Search results

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

plog tks fllopez65

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

tks to Alansidman,PNGBill,VBAInet, for your suggestions. I finally got it to work. As was suggested, I didn't need to use the property table, it caused alot of unnecessary problems. I only need the titlesearch table.

Property is the actual name of the table where some of the necessary fields are, not sure how I can get around not using it.

We were told to use sql for this particular query in access.

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

Tks to Alansidman,vbaInet and PNGBill, I tried your suggestions and they worked. fllopez65

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

Tks to Alansidman,vbaInet,plog. Got it to work. fllopez65

Will try suggestions. Tks. fllopez65

FYI...Tried renaming the table to "Heritage", regardless what the table is called still leads to the same syntax error message.

Plog Tried renaming the table to "properties", result was same syntax error message.Thanks anyway. Still trying. fllopez65

Alansidman/VbaInet Have attached a very sanitized version of the database,take a look and plse let me know what you think maybe causing the error message encountered. Don't you need tell access what table to that the expression needs to be linked to ie:table?

Will try like you say have to sanitize first. fllopez65

Alansidman and Plog I keep getting an error message on my second expression of my query(see attached). Note the original field is 19digits long, my left expression is supposed to pull the first 2 digits and my mid expression is supposed to start at the 3rd digit and pull it and the 4th digit...

Tks to both Alansidman and Plog, I'll try your suggestions. fllopez65

VbaInet Not sure what you mean by Left and Mid functions, could you expand plse? fllopez65

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

Thanks, I figured that out later. You have been most helpful. fllopez65