Access97 now fails with Insufficient Memory message after a recent memory upgrade from 500M to 2G Removed and re-installed ACCESS and indeed complete Office...

Dear Friends While appending data can we find out wether that record is unique ? If similar record is pre exists can we overwrite the record ?. I have...

Hi, In my table one of the column contain more than 3000 letters/words, and all are important msg, how can i put all the letters in one column...

Hi All, I have a formula in a query that calculates commission. The formula works great however, when there are 3 numbers after the decimal place, in need...

I would like to create a form and a report based on PARAMETERS selected by user. Because there are 583 possible selections I would like to make it easy for the...

hello, I have two columns in my querie. The first is Expenditure Authority and the second is Trans Amt. Sample data is below. Expenditure Authority ...

Hi, I have one table which is made from a tablequery. From this table I want to add everything to an existing table. The From table:...

I would like to write a query that inserts data into a table based on parameter data. The number of records inserted would be a parameter, but i also want...

I have a very large data set with events happening in time steps that are broken down into five minute increments. Over the course of two years the events...

Hi, I have a field called PartNumber that has values that are either A3452A or A2958B 030, or b21-A3982A 34A. What I want to do is to create a query that...

Not In ("Completed"," Canceled") I want to exclude the status of Completed and Canceled from my query. I tried using different combinations of the above...

Is there a way to format a field in a query to currency and display it like this: -$4,650.00 instead of this: ($4,650.00) ?

I have a text value that ranges from 5 to 9 characters. The last two characters are always two letters. All of the other characters are always numbers. I...

I am helping my brother with his mileage claims database, for under 10K miles you get one rate and another for over 10K. There was a simple update that...

In Access 2000, I need to provide a list of reps who service a number of cities. The search needs to be form based. The search will also need to be based...

I am trying to create some way of reporting the total values in a large number of Queries. All I need to do is to count the number of records returned by...

Please help - I need to run a query between two tables The two tables are linked by the . The date formate for both tables and are in Date/Time...

I have a column of diagnosis codesstored as text without the ".", for example, 03100, 1560, 95202, V08, etc. I need another column of the same codes with the...

I'm trying to move 1 record from 1 table to another. The table structures are identical INSERT INTO PATIENT SELECT PATIENT1.* FROM PATIENT1 WHERE...

In my Report (generated from a query) there are 4 Col. Bill Date , Payment Date, Diff , Factor Bill date : the date on which billing happened Payment date :...