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

    Previous() function not pulling previous record?

    I have a report I'm working on rebuilding in a new format that has two groups, which are then additionally sorted in the Record Sort Expert by date. The report calls for the previous month's data to be compared to the current month's, which had been done with the previous function in the former...
  2. mrpatak

    SQL INSERT with LEFT JOIN on Multiple Columns

    I've been bashing my head against this one for a while, but can't seem to figure out why this one doesn't quite work as expected. The function would be to take an imported set of data in a table (Sheet1) that has been cleaned for erroneous data, check it against the existing data and import any...
  3. mrpatak

    Complex record selection on multiple parameters

    Working on a record selection formula for creating a report with multiple charts, sorted by which "goal" they pertain to. A few of these charts need to display a certain date range stored in the database, the rest need to display a rolling year. The date range is essentially a financial year for...
  4. mrpatak

    Year to Date Calculation with two date fields.

    Hi all, Little bit new to Crystal (using XI), so bear with me. I have a Access database that includes two different dates for every data piece. Each one has a date for the month the data is collected, and the month that the data is reported (eg. a month could be collected for November, but not...

Part and Inventory Search

Back
Top