Search results for query: *

I re-examined the code and with some extra help it worked when I did the following: WHERE (((TABLE.FIELD3)<>"CRITERIA1" And (TABLE.FIELD3)<>"CRITERIA2" And (TABLE.FIELD3)<>"CRITERIA3" And (TABLE.FIELD3)<>"CRITERIA4")) Or (((TABLE.FIELD3) Is Null)); Thanks to all who helped. Jeremy

I tried the trim and it did the same this. It excluded all record with an empty string. I need to make sure they are not excluded. thanks

Here is the SQL in a generic form: SELECT TABLE.FIELD1, TABLE.FIELD2, TABLE.FIELD3 FROM TABLE WHERE (((TABLE.FIELD3)<>"CRITERIA1" And (TABLE.FIELD3)<>"CRITERIA2" And (TABLE.FIELD3)<>"CRITERIA3" And (TABLE.FIELD3)<>"CRITERIA4")); This SQL statement is used as an Access form's Record Source...

I simplified it best I can: SELECT [qryORIGINAL].CTRL_NBR, INV_ITEM.GSTYLE, INV_STYLE.ECK_US_ECCN FROM ([qryORIGINAL] LEFT JOIN INV_ITEM ON [qryORIGINAL].ITEM_NBR = INV_ITEM.ITEM_NBR) LEFT JOIN INV_STYLE ON INV_ITEM.GSTYLE = INV_STYLE.STYLE; The Query referenced above pulls from the database...

In joining two tables in a query I'm running into a problem. In the main table, the field entry is normal. For example Table1.ID = "ID_104" However in the Table I'm Left Joining the Feild entry has trailing spaces, Table2.ID = "ID_104 " When I try to join the two and run the query I get an...

Bummer, Now I guess I need to figure out how to do that. Back to the books. Thanks for all the advice. Jeremy

Thanks, mstrmage1768 I will try that Thanks, Jeremy

Unfortunately, getting the user to fill in the table is not an option. Consider, tables are locked user cannot enter new data, but needs to alter the report before it generates fully. Thanks to all for your suggestions. Jeremy

If a report field receives a null value, How can I give the user an opportunity to fill in that field? and, if its possible In the case of Multiple rows how would the user know which value to enter? For example: Query pulls: Item, Price, Weight Employee forgets to enter Weight Report...