Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jvleigh221
- Content: Threads
- Order by date
-
Too many records missing after query applied
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...- jvleigh221
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
-
Joining Tables with Added Spaces in Field
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...- jvleigh221
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Promt User to Enter Field
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...- jvleigh221
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
