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 strongm 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: SBLatta
  • Content: Threads
  • Order by date
  1. SBLatta

    Linking data between two types of data sources

    Help! I'm trying to create a report which compares the ending inventory of two user specfied months. I have that part working perfectly. Every month, we take a snapshot of our ending inventory data and append it in an SQL database. Now, the users want the report grouped by a field that isn't...
  2. SBLatta

    Query to return the most recent rows of data

    Hi all. I'm trying to write a PSQL query in Crystal Reports which will pull only the most current data for each product from a sales history file. The data looks like this (only not sorted), and is contained in a table called ORLINH: Custkey Itemkey Location OrdDate UnitPrice...
  3. SBLatta

    Populate a text box or label with Record x of y

    Hi, I found a thread I was hoping would solve may problem of how to put a "Record x of y" box on my form, but it's apparently too old for me to reply to directly. The solution which was posted on the thread is below, but I cannot figure out how to make the results show up on the form. I think I...

Part and Inventory Search

Back
Top