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