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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rdhatch
-
Fix for MS Access LEFT JOIN : Join expression not supported
Hi PH, Could you please elaborate? As far as I know, the Nz function returns a value for a field that is NULL. How would I use the Nz(variant,value_when_null) function to simplify this query: WHERE (LEFTJOINTABLE.id IS NULL) OR (LEFTJOINTABLEid IS NOT NULL AND (__PUT YOUR JOIN FILTERS HERE__)...- rdhatch
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Fix for MS Access LEFT JOIN : Join expression not supported
Here is the fix implemented as a function for use with LLBLGen in .NET 2.0: Ryan Public Shared Function getLeftJoinWHEREClause(Of TEntity As {IEntity, EntityBase})(ByRef myLeftJoinEntity As TEntity, ByRef myLeftJoinFilters As PredicateExpression) As PredicateExpression...- rdhatch
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Fix for MS Access LEFT JOIN : Join expression not supported
Problem: Cannot LEFT JOIN on x AND y when x and y are in different tables. "Join expression not supported" error. PROVEN SOLUTION: If you want a true left join - where records are optional - and you're filtering by multiple fields in different tables - Then I have your answer. To do...- rdhatch
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
