I posted this previously as "subreport with parameter query"." Although I resolved part of the problem I have yet to resolve it entirely. Thanks, Allen Browne...

Hi, I have multiple headers in my access 2007 report. I have all of the contents of the DETAIL section set to Yes for Can Grow and Can Shrink. One of the...

Having been growled at for being unaware of protocol I have taken advice from an MVP before sending this. If this offends protocol I apologise in...

I have a form that I set the SQL query to either if len(sParam) = 0 then sSQL = "Year=2007" Works fine I get all records for that year If len(sParam) 0...

How do I make a TextBox in a report show the number zero instead of a blank. Thank you beforehand.

I searched, and tried to utilize the answers I found, but I don’t have the skills to make them work. I have the crosstab query shown below which works fine...

After I run and then close a report I want a checkbox in Acknowledgement table to update...the table does show the checkbox updated. ....but after the report...

I have a subreport, and it previews properly. When I put the subreport in the main report, it shows the detail portion, but not the footer portion of the...

I have a % utilization calculation I need to do in a report where the denominator is the number of hours in a shift * number of rooms * number of days. Yhe...

Hello, How I view crystal reports (.rpt) with access 2007? Nico

Newbie Form / Report using code Question I am tring to generate a form with two combo boxes, using a 'Value List' as the source type and manually entered...

All, I have an inventory transaction table that houses all additions and subtractions of a particular part #. The inventory balance of the part # at any...

Good Evening: I have a report ("Invoice") which has 2 subreports, one for parts and the other for labor. When either has no data the calculations for totals...

I have a report with a bunch of unbound text box controls. The report is opened, and then I explicitly populate a few text boxes with data: DoCmd.OpenReport...

Is it possible to print a PDF file from within Access 97?

I've made a report titled HR Efficiency Report. This report contains the employee name, their pay rate and all of the information needed to calculate formulas....

I have a main report with 2 subreports in it. One of the subreports seems to be holding up the report when it comes to running and printing. When I run the...

I am using Office 2003 and I have everything set up to provide me with Annual and Monthly Calendars that are perfect when they print. What I need now is a...

Is it possible to programmatically write the name of the query the report is based on in a text box in the report footer.

Hello I am creating an Interview schedule report for the Faculty of Medicine Admissions. Before this year they did it by hand...but now that we have more info...