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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. bwhalen1

    Multple Connditions on a JOIN - Works fine in SQL Server

    Well I figured out the pass-through query- but now I get another error. First Query: SELECT SS.DatePromised, SS.Customername, SS.CustomerNum, ID.MfgCode, ID.CatNum, ID.ProductDescription, ID.Price, ID.PriceUOM, Cint(SS.OrigRegNum) AS OrigRegNum, SS.CustPO, ID.OrderQty, ID.SalesType...
  2. bwhalen1

    Multple Connditions on a JOIN - Works fine in SQL Server

    Hey PHV - I am having a hard time finding some good examples out there - still pretty new to this - do you have any resources that could illuminate this to me. I apologize for my lack of knowledge in this subject, but maybe you could point me in the right direction.
  3. bwhalen1

    Multple Connditions on a JOIN - Works fine in SQL Server

    OOPS I MEANT WHERE instead of on above "WHERE SS.OrigRegNum = BOCustRegNum1 AND ID.CatNum = CatNum
  4. bwhalen1

    Multple Connditions on a JOIN - Works fine in SQL Server

    Hey PHV & Skipvought - Thank you for the reply - that's what I was thinking: Im not a big access fan - and still learning. @skip: my table names are diff in access so I just drop the dbo but yes I believe you are right. @ PHV Pass through query: USE ********* SELECT ... PO.PONum ...
  5. bwhalen1

    Multple Connditions on a JOIN - Works fine in SQL Server

    Hello, New IT professional here - working in SQL - Need to deliver query to End Users via Access - I have this Query in SQL server which runs as expected. Access has all sorts of problems with the join. Would anyone be able to lend a hand? USE ********* SELECT SS.DatePromised ...

Part and Inventory Search

Back
Top