Search results
-
R
adding values between 2 tables
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... -
R
Eliminate items in a query by selecting text in the description
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... -
R
remove blanks from item number in a table
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...