Search results

Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this? Thanks.

In Excel I have a sheet with about 3000 rows. Each row has an id. I need to retrieve a field from an Access database for each id in the Excel file. I know how to query the Access database from Excel, but I don't know how to set the query to use the id's in the Excel sheet instead of an Access...

Let's say I have 2 tables, tableNames and tableSales. How would I select all of the names from tableNames that don't exist in tableSales, or exist in tableSales but have 0 sales? tableNames has 1 column for names, tableSales has 2 columns for names and amount. This is an example but very...

Hi, Lets say I have a table with 4 fields - product, location, transactions, cost How do I select all the products (and their location) from the table that exist in the table more than 4 times with transaction=0 and cost>3? There might be records for the product with more than 0 trans or < $3...

Lets say I have 5 rows of data in my database. Each row has 3 fields and the first 2 fields are the same in each row. I need to return the first occurrance of the third field. So if this is my database: A B C A B D A B E A B F A B G And this is my input: A B I need a query to return this...

Hi, I have a table with two fields and thousands of rows. In some of these rows, the second field has a duplicate. Like the following: a 1 b 1 c 1 d 2 e 3 How would I write a query that returns all unique rows and just one of the rows that has a duplicate second field? Such as: a 1 d 2 e 3...

How do I edit the field list of a form? I need to add another field to it. Thanks.

How do you select duplicate fields from a single table? If the table looked like this: a 5 b c 5 d e 5 f g 6 h z 4 y I would need to select the first three records because they each have a duplicate field2 value.I'm thinking it would look something like this: SELECT field1,field2,field3 FROM...

Hi, I'm trying to create a query that will return strings from one table that don't contain certain words which are located in another table. So I have two tables. One table has a list of strings, and the other table has a list of words. I want the query to return all strings from table A that...

I have a table with 1 field which contains strings. In an Access '97 module, how do I loop through this table and assign each string to a variable? For example, lets say I have the following table: Field of Strings -------------- This is string1 This is string2 I need to get the string in the...

How do you run a SQL query from an Access '97 module? I need to count the number of rows in a table in the database and then assign that value to a variable. Thanks.

Hi, I need to split a string into an array by the space character but I'm working in Access '97 which doesn't feature a split() function. Does anyone know the equivalent? Thanks.

I'm trying to write a module in Access '97 and I need help with the following: 1. Counting the number of rows in a table and assigning the value to a variable. The macro would loop this many times. 2. This table only has one column and each row in this column contains a text phrase. I need to...

I have two tables in my database. Both of them have strings which are up to 5-6 words long. I want to make sure that the strings in one table dont exist in the other even if the words within the strings are arranged differently. So how would I select a string from both tables and re-arrange...