Recent content by Raptor136

Fixed it. Decided that I was tired of messing with it. Ran an update query on the original table. Changed all the nulls and ""'s in a !. Now there are no blanks but the append query works. Thanks for all the advice. Phil raptor136@adelphia.net

Well, I looked over the table definitions again. Nothing there, no validation rules at all. I ran the append as a select and it picked up all the records, but as an append drops 2 of them. I ran each query that processess the data one at a time and checked the resulting table, so it *is* the...

It says "Microsoft access set 0 fields to null due to a type conversion error, and it didn't add 0 records to the table due to key violations, and 0 records due to lock violations, and 2 records due to validation rule violations. Do you want to run the action query anyway? To ignore the...

HI, I am receiving an error message to the effect that access is not adding a single record due to a validation rule. My help system is non functional. I looked at the single record and cannot find a unique item causeing it to fail. I also checked the table field definitions and non of them...

Warwick, You are the bomb. I was trying to use "last", and it didn't work. I tried using "max" showing all fields. Your way did it. I then created a select query which joined the "maxof" field with the original table so I could see the restricted set of tables...

I have the following table, where I am trying to select the last record of each ERO number. Obviously selecting Last in the Query by design isn't working. My Help system is dead and the install CD is cracked. Thanks in advance. ID ERO DEF1 DEF2 11506 UP686 410- 30 11507 UP686 TEDD ALGN...

I understand what you are saying. In the actual tables, I have an autonumber ID as primary key. I can create a Select Query that orders by ID. Once they are in order, Fld1 will sometimes be repeated. The second instance of matching data in Fld1 will always be kept. Does this make sense...

Hi all, I need to insert the most recent instance of a record into another table. Please see below. Thanks. Fld1 Fld2 Fld3 AAA 10/1/01 Pending AAA 9/30/01 Received BBB 11/01/01 Sent CCC 12/1/01 Sent CCC 1/1/02 Lost CCC 7/1/02 Found I would need to insert the 1st...

Hi all, Here's a poser. I have a table that has either 1 or two records with the same info. If I have only 1, then fine. If I have two, then I want to keep the second. example Fld1 Fld2 Fld3 AAAA xxxx nnnn AAAA 1234 3456 BBBB uuuu jjjj CCCC oooo 9999 CCCC...

Hi, I am trying to figure out how to assign a value to a field from a text report. Here's how the table looks once the import is complete. ERO_No Job_Status Job_date XP001 INSHOP 8/1/02 BACKORDER 7/1/02 RECVD SHOP 6/30/02 XP002 RECVD...

Hi, I am trying to figure out how to assign a value to a field from a text report. Here's how it looks once the import is complete. ERO_No Job_Status Job_date XP001 INSHOP 8/1/02 BACKORDER 7/1/02 RECVD SHOP 6/30/02 XP002 RECVD SHOP...

Hi, I am trying to figure out how to assign a value to a field from a text report. Here's how it looks once the import is complete. ERO_No Job_Status Job_date XP001 INSHOP 8/1/02 BACKORDER 7/1/02 RECVD SHOP 6/30/02 XP002 RECVD SHOP...

Hi, I am getting a VBA syntax error on this line. Any ideas why. Please be nice I am a learn as I go kind of guy. :) TIA -- Rap DoCmd.RunSQL CREATE INDEX PrimaryKey ON ROOTCOPY (ero) WITH PRIMARY UPDATE DISTINCTROW root000 LEFT JOIN rootcopy ON root000.ero = rootcopy.ero SET...

vbslammer, Do you have an example of code that does the line-by-line comparison you were hinting at? Once I see it, and play with it, I am pretty sure I can adapt it. thanks -- Rap raptor136@adelphia.net

Thanks everyone. Never hurts to hear good advice, 'preciate the time. -- Rap raptor136@adelphia.net