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 derfloh 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. kooley

    CRXI connecting to iSeries DB

    I have been told that CRXI can connect to an IBMDB2 data source. I am having trouble determining the steps to create this connection.
  2. kooley

    ORDERBY Property

    That is the conclusion I was coming to. Oh well! Thank you for your help. I am thinking of numbering the statuses in the order they need to appear in the report & then the sort of ascending or descending would work. Have a wonderful day!
  3. kooley

    ORDERBY Property

    I have a report that groups on a status field that is a combo box. I need to specify the order that the statuses should appear on the report (other than ascending or descending). Can the ORDERBY property be used for this & if so, I am unsure as to the proper syntax to use. Thank you for any...
  4. kooley

    Access Query Criteria

    Thank you everyone for all of your suggestions! I was finally able to get my expected results using 2 separate queries that then combined into a final query for the report to run on. This is the best site for ideas & help! Happy Holidays to all!! [thumbsup2]
  5. kooley

    Access Query Criteria

    I do have the properties set to display all fields. Here is the SQL view for the 1st query: SELECT CUSTOMER.[Account Number], CUSTOMER.[Borrower Last Name], Disbursements.[LIP or Savings Account], Disbursements.[Check Date], Disbursements.[Amount Disbursed], CUSTOMER.[% Complete]...
  6. kooley

    Export random excel data to access table

    If you are looking to just bring data from a spreadsheet or even an entire workbook, start in Access & go to File, Import and navigate to your Excel file. It is very user friendly & walks you through. You may find that depending on the formatting of your Excel file, you may have to do the...
  7. kooley

    Access Query Criteria

    I tried adding the "DateAdd" function within my query & it's not what I need. I have now tried writing a query with the "account type" & "% complete" criteria. Then I have created a query based on that query. Within this final query, I have placed my Max Ck Date field using the following...
  8. kooley

    Access Query Criteria

    I have a Query that includes a field called "Check Date". I need to have criteria that tells the DB, only give me records that do not have any check dates greater than or equal to a specified date. I have tried using the MAX sort function with "<=(Date()- 120) or IsNull". The problem is that...
  9. kooley

    Show parameters from a query in a report header

    When the report is run, prompts come up for the user to enter a beginning date and then another prompt for the entry of an end date. So, it's not really in a form. Any other ideas?
  10. kooley

    Show parameters from a query in a report header

    I have a query that runs based a "Closing Date" range. I have a report that runs from this query & I would like the date range that is entered to appear in the Report Header. I have tried pulling the "Closing Date" field to the report, but the results are inaccurate. (Example: I enter a...
  11. kooley

    Access - Grand Totals in a Report

    I have a report that I have grouped by account number. Each acct# has multiple fees and I only want the sum of the fees for each acct#. I have pulled the sum of the fees for each acct# into the group footer. Now I need to get a Grand Total of all those sums. I have written the calculation to...
  12. kooley

    Unlinking a linked Excel Worksheet

    I have an Excel worksheet that is currently linked to other worksheets. I need to be able to email this worksheet, but I do NOT want it to prompt the recipient to keep existing information or update existing information. I have tried to save the worksheet in a Web format, but all of the...
  13. kooley

    Running Calculation (subtraction) in Access

    I am trying to have a calculation using a running total in a report. The object of the calculation is to take a beginning loan amount or savings account amount (depending on the group) and then subtract the Amount Disbursed from first the loan amount/savings amount and then the next Amount...
  14. kooley

    easyLENDER/Crystal user needing help

    I use Crystal reports with FiServ easyLENDER and I am having trouble locating other proficient users that know both systems. Please contact me if you have this knowledge.
  15. kooley

    Counting specific dates

    Thank you! The &quot;Sum&quot; suggesstion worked like a charm!
  16. kooley

    Counting specific dates

    Thank you for all your help! The &quot;Sum&quot; suggestion worked like a charm!
  17. kooley

    Query using unrelated tables

    I am trying to write a query that will pull information from 3 different tables that can not be linked in any way. Is there a way? My formulas in the query are getting confused because the same fields exist (ie Account number, Loan Amt)in all the tables but there is no common information in...
  18. kooley

    Counting specific dates

    I am trying to count the number of records for the last five business days in one day increments on a report. I have been playing around with a formula and this is how far I have gotten: IIf([Registration Received]=Date()-1, Count([Registration Received]=1, 0) This is for yesterday's records...
  19. kooley

    Duplicate details due to User Defined Fields in LOS

    Within our LOS, we have User Defined Fields (UDF) to be completed. They are different types, (ie, Character, Date, Currency, Percentage). I have written a report that only wants to look at a couple of the Character type fields. I've written an &quot;if-then-else&quot; function looking at the...

Part and Inventory Search

Back
Top