Search results

Using Access 2007. In my report I have a group footer where I have inserted a page break. When I go to print view, there is a blank page between each page with information. Margins are set correctly and without the page break there are no blank pages. Thanks in advance for any help EJR

I have a report with information in the detail section of a report by account numbers and grouped by a customer number. I want to show a section footer for the customer number only if the number of detail records displayed are greater than 1. Any help will be much appreciated.

I have a query that creates a new text field using the following: REL_ACCT: Left([CRAPPL],1) & "18" & Format([CRACCT],"0000000000") This creates a 13-character field for me which is what I want. An example of the new field would be "D181122334455" The number of characters in the [CRACCT] field...

I have run into a problem with an ODBC table connection. The table I am connected to exceeds the number of fields allowed in an Access table. I am using Access 2003. When I looked on Microsoft help site I think the max number of fields in a recordset is 242 so I am unable to see all of the...

I have uploaded a zip of the database with very basic tables and report. You will see on the report that the sum in the section footer increases by the number of lines in the detail section. Thanks again for your help.

Using two tables. Table one has account information with one recordset for each account. The Account Number field links (outer join) to a collateral table that has multiple recordsets for most account numbers. The linking field is account number and then a collateral id field in the second...

I have a report that has information displayed in the the following groups: Name Field : Has Header & Footer Account : Has Header & Footer, fields include [Balance]. One record only. Details : Has multiple rows for different collateral. When I try to sum the [Balance] field, it takes...

I want to print text based upon the content of the field but need more than the IIF statement. For example, if the field contains an "A" I want to print "Active", "C" I want to print "Closed", "N" I want to print "New", etc. Thanks in advance for any help. You guys have always had an answer...

I am creating a query which determines the number of days a payment is delinquent. Is there a function I can use in a query field that would look at the numeric field and if the value of the subject field was: < 60 Days "30-59 days" < 90 Days "60-89 Days" <120 Days "90-119 Days" >=120 Days...

I am trying to break out a field where city, state and zip codes have been consolidated. I want to create a field where I am able to ready the consolidated right either right or left until the first blank space. For example: "pittsfield ma 01201" I want to read the field to break out...