Recent content by !Rdooley

This query just adds the values of two fields from 2 different tables. I have this formula in my query. I want to modify it to accept null values FIELD6: First([EXTRACT_O32-05]![F6]+[EXTRACT_O35-05]![F6]) I tried: FIELD6: First(([EXTRACT_O32-05]!(Nz([F6])+[EXTRACT_O35-05]!(Nz([F6])) Any...

Thanks Alot :D

Hello all, I have a table that contains records of merchandise. Item #, Description, Price. The description field is text and I want to remove any records that have the words "stay" or "stays" in the full description. Can I use the [criteria] in a query to <>"stays"? I tried this and...

Thanks Use a version of the mid replace above and applied it to the entire column. Worked great Thanks all!

ID is not in the item number just O## #### ##. Plus I am dealing with several different records using the same format. So I will need to update the entire column and not just on record. Thanks for the ideas , so far.

Just O35 1234 05 Thanks, BTW Access 2000

remove blanks from item "numbers" in a table UPdataed at 3:11PM I have a table with item ID's based on this format "O35 1234 56" and I need to remove the spaces in between. An update query would be the easiest I just cant get the positions right. I read the following thread...