Using Access 2003 in the report footer I want to the count the number of times that a consultation occurs on a Monday, Tuesday, etc. In the detailed section...

Forgot to say that this is Access 2003 On Wed, 29 Jul 2009 12:54:27 -0600, wrote: I've made a couple of reports that print to a...

Is there a way to know, when the Page footer fires, the total height of the report page up to the bottom of the last detail line when there are multiple goup...

In my report I am totaling sales by each year. I do this by using a text box for each year with this: =DCount("SalesDate","Sales","SalesDate=#1/1/2009# And...

After I make something visible in the Page Event, how do I subsequently make it not visible for the next page?

How do I add a watermark to my reports? Thanks!

how can i change font size in a text box based on content? say if txtWell1.Text = "POSITIVE CONTROL" for example? tia, mcnewsxp

I have a subreport whose data intermittently does not appear on the main report during print preview mode. However, the subreport data always appears when...

Hi, I have a report based on a cross tab query. The query has Product and Answer as Row headings and Month as a Column heading. The value is the counts of...

I want to use the output of one query and use it in another query. How can I do so in Access 2007? I will be filtering some records based on the Max(date) in...

I created my report with a page setup as legal size using Microsoft Access 2003 from my home computer. When I print the report in my office using Access...

We recently installed Access 2007. I cannot export reports to Excel. The Excel icon is not "highlighted" when I try to export. I've tried right clicking...

Is there any way to auto-adjust the Detail section to fill in the available space on a page? I have fields that 'can grow', so it's difficult to guess how...

Hello- Access 2002 user, have a subreport which provides data when available, however, if no data is available in the subreport, the header does not show in...

What's the formula to highlight in a report when 2 records are the same? I Just want to highlight them. Thank you.

Left, Right, Top and Bottom Padding all seem to default to .0208". If any or all are set to 0", they seem to default back to .0208" Is there a way to set...

In office 07; I'm trying to format a field in a report. I can change the color of the text depending if the order is late or due within the next 30 days. ...

I have created a command button that prints 2 reports. I want to add a 3rd report to print but only if it meets criteria. For instance, if leave is for a...

I have a query using 3 tables that have relationships and it works great with no criterias (shown below). I also have a report that uses the same query and...

For Access 2003 I have a report that gives employee attendance information. There is no report header. I want to set up printing so that, if needed, it...