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: Harlequink
- Order by date
-
Union Query problem
It says you can not have a OLE or a memo in the union. Its OK though, I just changed my Note field from memo to text. It works great now thank you very much.- Harlequink
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Union Query problem
It says you can not have a OLE or a memo in the union. Its OK though, I just changed my Note field from memo to text. It works great now thank you very much.- Harlequink
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Union Query problem
I get an error because Note is a memo. My SalesLog Table is read only and I don't know how to change it.- Harlequink
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Union Query problem
I have two tables, SalesLog and ReturnAuthorization. I used this union query to join them SELECT ALL KIOrder,RANumber, CustID,Items,ScheduledDate,TotalCost FROM SalesLog WHERE DateShipped = null ORDER BY ScheduledDate ASC, KIOrder ASC , CustID ASC UNION SELECT ALL KIOrder,RANumber...- Harlequink
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
