Search results for query: *

I am trying to select specific records from an Access database using an ODBC connection. Here is the formula I am using: {@ComingDue} = 1 and ( if {?Officer} <> "All Officers" then {Exception_Table.Officer} = {?Officer} else if {?Officer} = "All Officers" then True ) and...

I am trying to select specific records from an Access database using an ODBC connection. Here is the formula I am using: {@ComingDue} = 1 and if {?Officer} = "All Officers" then {Exception_Table.Officer} = {Exception_Table.Officer} else {Exception_Table.Officer} = {?Officer} and...

I have a report created in CR 9 Standard. Data pulls from an Access database with an ODBC connection. I have placed the report on our intranet using ActiveX to view. My problem is this. When you open the report, the first page displays correctly. As long as you use the "Next page" button...

For some reason, when I preview my report, on some pages the last 3 or 4 records at the bottom of one page will print at the top of the next page. I do not have duplicate records in my database, so I don't understand why this is happening. Anything I can check??

I am using the following formula for aging records in a crosstab: If datediff(&quot;d&quot;,{TITM1301.ExpireDate}, currentdate) in 0 to 30 then &quot;0-30&quot; else If datediff(&quot;d&quot;,{TITM1301.ExpireDate}, currentdate) in 31 to 60 then &quot;31-60&quot; else if...

Is there any way to add a conditional summary field? In my table, I have three fields that this will involve: LoanNumber (Can be numeric or alpha-numeric) Balance (Currency field) DirectDebt (Currenct field) If the loan number is a numeric value, I want to add that amount into my subtotal...

I am trying to sort records by their category number (i.e. 225-1, 225-2, 225-3,...). However, 225-10 prints before 225-2. How can I keep this from happening? Thanks!

What kind of damage will it do if you relate the same field in multiple tables? For example, cna you relate one field in table A to fields with the same data in tables B and C?

I need to figure out how to automatically run a macro when a file is opened. I have tried, but it seems all that is happening is that the file is opening, but no macro is running. Any help would be appreciated. Thanks!

I need help figuring out how to count items that have aged 0-30, 31-60, 61-90 and 91+ days, then total. I have 7 columns: Item Number Item Description 0-30 31-60 61-90 91+ Total I only need the item number and description to show up if there are aged records for that particular item. Hope...

LOAN1301.CollCode (Text field) LOAN1301.Balance (Currency field) LOAN1301.DirectDebt (Currency field) What I want to do is if LOAN1301.CollCode is NOT a number, I want to return the LOAN1301.DirectDebt value with a label of &quot;Direct:&quot; in front of it. Other wise I want it to return the...

I have five tables I need to relate, but I cannot figure out the best way to do so. Table 1 - Customer Info (Acct #, Name, Address, Etc.) Table 2 - Acct Notes (Acct #, Line #, Line Description) Table 3 - Collateral Info (Acct #, Line# of Description, Description) Table 4 - Tracked Item (Acct...

I have a report that the details section is split into sections a, b, c and d. For some reason, section d is printing before section c. I'm about to drive myself crazy trying to figure this one out, so I thought I should ask for help. Any ideas?!?

I am trying to combine two fields into one, but separate them with a -. For example, 111-3. I have tried the following formula, but I get an error when I try to save it: {Test_3.Category}+&quot;-&quot;+{Test_3.SubNumber} I get an error that says &quot;A number, currency amount, date, time, or...

I am trying to compare data in two tables. I have a master table and a purged table. I want to compare the two tables to where if a record exists in the purged table, I do not want it to print on my report. The formula I created did not work. This is what I tried: If {nosig.Account #} <>...