I have a report where I want to Sum the qty of sales of a certain product but I also want to display the Sum of total sales (dollar value). ProductX_Qty ...

Hi All I am currently upgrading a DB from Access 2000 to 2007. I have been using a Form "Report Date Range" which has the following : Private Sub...

Hello All I Need To Initialize A For Each Loop For The Setions Of The Report Put The Keyword Sections Isnot Available To Use It Such For Each Section In...

I tried the carriage return CHR(13) in a textbox but all it does is put a small box where I want a new line and continues the text on the same line. Any...

I generated a report that shows PartNo, Date of Last Shipment, Qty of Last Shipment. Because there may be more than one shipment of each PartNo, I grouped...

How would I go about adding a second data series to a chart in Microsoft Access to be displayed on a dual axis chart?

I have created a delivery table that contains all of the usual fields , Pickup, Delivery, Billing, NoPeices, Weight... etc. The table is updated with...

Q1- I have label with control source =Count(*) & " " & ("Records") and it works fine. I need to have the text placed in front of the =, i.e., to print as...

I am using ACCESS 2007. I am trying to print a report. Paper size is slightly longer than A4 length. Paper itself is also longer (35 cm). The width is same...

I have created a macro in my Access application that uses the RunCommand action with the SendToExcel command. When I run my report in print preview mode this...

I would like to export my report which contains 4 groups layer to an excel format without showing all the groups! Exactly the way Crystal Report does. Could...

I have an access database report build up complete with parameter query and some charting and graphing. What is the best way to present the time based...

I have a report and subreport working just fine as far as outputing the data I need. The problem is formatting. When I click on properties for the...

Is there a way to put a text box in a report from a table not in the field list and only have one field show. In other words, I tried putting control source...

Currently working on a project where the client has requested that a Service Mark be added to a text field - the equivalent of a super- scripted "SM" by the...

I have a query with a field called "Address" Address: (qryNames]!) & (" "+!) & (" "+!) & (" "+!) & (" "+!) & (", "+!+",") & (" "+ !) & (" "+!)) When I runt...

Hello, I have a report with a subreport in the group header. Both the detail and subreport have two columns (width 3"). Column layout across, then...

In an Access report, I'm presenting the top 15 cost values in the detail section. I have a counter to do start a new print page. That is working, but I...

I am using the template off of MSOffice Access 2003 "Inventory Management". I am running in 2007. I want to produce a purchase order form and purchase...

I'm creating a "mail merge" type of report that will allow secretaries to print labels. One example will print a student's name, their homeroom teacher, and...