Search results for query: *

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

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!

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

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]

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]...

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

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

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

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?

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

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

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

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

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.

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

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

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

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

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