Recent content by boethos

Sorry for the sparse postings. Been busy. You know how I.T. goes. Yes, been through boku docs. I figured this forum would know more by experience the best way to do it. I'll be tied up next week, will attack it again the following week. Thanks everyone for your input!. Within the last...

I got the query to pull from both the DB and the local import from Peachtree. I had to set the index field in Peachtree to Large Number to match up with the Access db.

For now, just the one. I don't know what type of field is IN Peachtree. At some point I want to link the Acess db to Peachtree for live data sampling by the acct dept. For now, I just imported the data into Access so I can do prep and match the records we have indexes for in PT, and I can...

Thanks fellas. I didn't know autonumber was a long integer. I'll look into that. We have property (land, house, etc) for each record. We're generating our own internal 'index' number to identify each property. We're wanting to match it up to the Peachtree database using that index...

I have a table that generates a new autonumber for each new record. I need to use that number in other queries, etc, but in those queries (and odbc connections) it's a Number field and when I try to join it to the autonumber field, it's a type mismatch (no surprise). I want to create a second...

I did exactly that. I have 310 records. Wooooowwwwww. Looks like what I'm looking for! Ya! Thank you, thank you, thank you, thank you for your patience. :):cool:

So these are three separate queries? If so, I tried them and am getting all the records. I'm missing something. Thank you for your time.

I cut off the sample to get the table to you quicker

I did try that, but could only get it to find dupe of one column, not checking two columns. I don't need the dupes of owner and property, I need same property, different owners.

Here's the db with both tables. Even though addr like 1001 10th ave have names rearranged, we can handle that. We'll just standardize the format. 1002 12th Ave is what we are looking for - change of owner. 1010 10th ST is what we are looking for also. Change of owner. The first table...

I'm getting you a sample output table.

That's in the access database I sent.

I changed it to an access file. It has raw data; both addresses with new owners and addresses with different owners. I'd like to select (to a new table, or whatever) the addresses that may have changed owners from one month to the next so we can change who we bill to. Ultimate goal is an...

See attached Access Database sample. A&B will show as different names, only because they are input in different format. C&D will show as different names so we might know that the property changed owners. E&F Same. G&H Possibly changed owners, but it should be selected since the names are...

Ok. I got that to work, but it only gives me a count of how many times it's duped. I need the table to show the addresses and owners after it selects duped addresses.