Search results for query: *

I am scanning in addresses and trying to create a db with these addresses. Once i scan them and clean them up a little they are in the following format... John Doe 123 Main Street Cleveland, OH 12345 Jane Doe 234 Main Street Akron, OH 23456 Jen Doe 345 Main Cleveland, OH 23453 I have a list...

I need help setting up and ODBC link to run queries on a server. I'm not really sure all what ODBC is but I run several queries in access and it bogs down my computer. Well, I now have a server so I heard I can run the actual queries on the server. Any help is appreciated.

I can't figure out how to do this. I have a query that produces the following results: A 1 234 A 2 34621 A 3 2356 A 4 4571 B 1 23556 B 2 2345 B 3 3466 B 4 2356 C...

I need to flag records that have the same name and phone number. For example, Suzy Smith 123-456-789 & Suzy Smith 123-456-789 would need to be flagged PM1. The next match, john doe 456-789-123 & john doe 456-789-123 would need to be PM2 and so on. Anybody know how to do this?

I have a text file that has 2 fields with binary data. When I try to import the file, the records with nothing in those fields get all messed up..Any suggestions?

I have one table with a list of different values. I have another table that has a field that has values from the first table somewhere in the field.. Table 1 Street Drive Road Circle Cove Table 2 1234 A. Street 3556 B. Cove What I want to do is if a word in table 2 matches a word from table...

I'm trying to Ltrim leading spaces in a text field. I have checked the table design and there are no validation rules, no keys, or anything else that could cause a problem and data type is set to text. However, when I try to do the update, I get the big long error saying that 0 records were...

How do you search for the first occurance of a number? I have very inconsistent data. However, it always begins with alphanumerics. I tried using something like InStr([# 1 Alphanumeric Address]![ADDRESS1], Like "*[0-9]*") but I can't seem to get my syntax correct. Any suggestions?

How do you search for a quotation mark?