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 SkipVought 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. ckelsoe

    Dynamics SQL question RE Statement Aging

    Thanks for the reply. The company had two large GP consulting firms say that there was no way to create the statement like the company wanted in GP. I was able to create the statement like they wanted in the Access report writer. I have figured out how to accurately calculate the balance brought...
  2. ckelsoe

    Dynamics SQL question RE Statement Aging

    I have created a custom statement in Access. I am using RM00101 for Customer data, RM00103 for aging and balance information, RM20101 for open transactions and RM30101 for transaction history. Based on those tables, I am accurately (except for NSF cases) creating statements. In addition, I am...
  3. ckelsoe

    Nested Query Help Needed

    Thanks. I figured that out. I was overcomplicating the problem when a well designed sql statement like yours was the solution. I appreciate the help.
  4. ckelsoe

    Nested Query Help Needed

    Hi, I have the following scenario that I am not sure how to best tackle. Any advice or examples is appreciated. I am creating a stored proc that requires a code to be passed to it. In return data gathered from 3 different tables will be returned. The big catch is that 1 of the tables resided in...

Part and Inventory Search

Back
Top