Search results for query: *

Our company uses Fedex online. Fedex online offers a download of your shipping history to be saved. The format is txt. The data comes in such as this: Tracking Number: 999999999999 Date May 1 2002 12:00 John Doe Company Name Department 100 Main Street Anytown 99999 US 9999999999 I have...

Yes! The subquery worked. (See code below) Thank you! SELECT [Hospital], [Title], [FName], [LName], [Street], [City], [State], [Zip] FROM Market WHERE (State IN ('NY')) AND Hospital NOT IN (select Mailing8_21.Hospital From Mailing8_21) AND Hospital NOT IN ('Nyack Hospital') ORDER BY...

In trying to run the following code; Access is asking me for parameter values. I'd like to run a query on Market and exclude any Hospitals that were included in Mailing8_21. I'm having complications running sql statements as my handbook presents. Could anyone refer me to a publication that...

Thank you for the responses and suggestions. I have been successful with the 2nd suggestion by tlbroadbent without the "=" operand. It seems ACCESS is not reading the "=" or "!=" operand. And the selection for the states using the "IN" reserve word has...

I have been unable to manipulate ACCESS to read the SQL statements below. I have been successful in the past. I have been unable to detect why ACCESS does not meet any of the conditions. (Where etc...). The code below gives me the complete contents of both the Market and Trends tables. What...

Thank You! Geek. Did the trick. I was making it much too complicated. Very grateful. J

Trying to merge an Access DB in Word. The Word document consists of 4 separate records per page. I have been unsuccessful of capturing 4 records per page. I have been only able to capture 1 record per page; that record is repeated 4 times per page. I had been trying to use field codes to...

I have imported several files from excel and saved them as access files. I did run a sql statement with them including a union and "order by". It seems that now when I attempt to access these tables to add records through access or run queries with them, I get an error stating...