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...
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...
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.
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...