First let my apologies. I posted a question earlier but I can't find we're I posted it! I would like to know if there's a way to auto number an invoice...

I've created a Pivot Chart and would like to add value labels to the columns. Is that possible?

Hi there, I have a Report which is based on two tables. I have a query set up within the Record Source of the Report to return values to the report. In the...

I have a form containing some text fields (orders) as well as a combo box (customer id and name). The record source of the form is a query joining the two...

I have a form containing some text fields (orders) as well as a combo box (customer id and name). The record source of the form is a query joining the two...

The front page of a report has fields that a user can change according to their needs. Is there a way for the user to specify the font type and size for each...

I have a report that takes all issues from a certain date range and counts them. The report shows the sums only. I'm trying to sort by the sum in descending...

I have a field that I need to calculate a conditional running sum that resets each calendar quarter. I have a formula that I am working with but receive the...

I have 3 different tables I would like to put into one report. The common theme being the Route #. The tables are information on do not delivers, required...

I use a report to show all systems located at a specific customer. When a customer has more than 20 systems, I would like a new report to start with all the...

Is there a way to automatically generate an invoice number in Access 2007? Invoice report is built but needs a invoice number to be self generated. Thank you...

I have a simple report. I am trying to get 'Invoice Dates' on my report, which is dynamic and controlled by some VBA code (I can post the code if it’s...

I'm using the following code from the wonderful Allen Browne which works perfectly in an either or scenario (either by Start/End Date(s) OR filtering by client...

How can I make a report, when it's opened, ask for user input? I need to have the user select a name from a list & report on that name's record. Is this...

I have built a report that attempts to compare year over year changes in commission. There are 2 groups in the report on "team" and then by "year". If the...

I have a main report with subreports. The main page is setup to have columns down then across. I have label boxes to the left and text boxes and subreports...

Using Access 2007 and SQL Server 2008. Is there a way to display SQL Server Reporting Services reports in Access 2007? If so, links to documentation/examples...

I have used check box datatype in my database, also created a report, it is all looking fine, but when i export the report in to excel or word or html, the...

I'm trying to print labels, each with a group header and then a variable number of detail line. The report should go to the next label (2-3/4" high)...

Hi, I have a form (titlepage) with a command button that prints a report (titlereport). The report has a text box that gets its data from a memo field in a...