Search results

my row source is coming from a table with 2 columns. Col 1 is name, Col2 is query_name. I want the combo box to only display 1 column with the name, however I want the query_name returned for an onchange event so a query by the same name will run(from a macro). My current rowsource code is...

I'm trying to create a transfertext macro to import a delimited .txt file. I keep getting a "microsoft jet engine could not find XXXXfile. The file path name I believe is correct. My situation is this: I receive several daily .txt file reports via e-mail. I want to automate importing these...

The UNION query looks like it will do the trick. I found an example and it doesn't look to difficult. My question is where do you actually write the SQL in Access for the query?

I want to make a single table from several tables that contain essentially the same fields, Problem is I want all fields and all the data in the tables. Access seems to only accept parts of the data. Is there a way to accomplish this? Thanks, Eric

I'm try to limit my returns in a query. It's a customer list that I want to return all states except 5. If I use the "not" and the state abbreviation in the critera field it works fine for one state. When I add the other states only the first listing is left our. Not "PA" works fine Not "PA"...

That worked great. Thanks Chris.

I need a query that will return only the first character in a text field. I have done this before but can't seem to get it to work. The field name is "First Name". I have tried the following expression from the expression builder "Left (First Name, 1)" But this does not return the result I'm...