I have two things that I’m trying to do in an unbound text box in my report. I have this =Format(!!,"q""Qtr""yyyy") which returns “1QTR2010� but I...

Hello all - I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field...

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

I have a bar graph which displays workers by widgets by months. X axis = Months Y axis = quantity of widgets Bars = worker names The report *must display...

Hi All, Been trawling around for a solution to this problem. The problem is pretty straightforward, yet surprisingly complicated to solve. I have a...

I have a report for a query that pulls from 3 tables. The main table contains employee hours by month and budget code. The supplemental tables contain...

I'm a bit new to Access and trying to find my way around it. I've created my tables and forms etc and i'm now trying to create reports from the data that is...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

Can anyone tell me how to hide Group Footer based on a condition? Below is an example of output. I want to display subtotal only if number of projects are...

I have a report that I am designing to work as an invoice using company headed paper. Therefore I wish to be able to have wider 'blank' footers for the...

When I print a report I don't want the page footer to print at the end of the report I only want the report footer to print The page header must print on...

I have two reports that I have created using Access2000. One will print, and nothing happens when I click print on the other report. I've checked the...

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

i would like to know how to create a report that represents an income statement. i've done my query but got stuck creating the report. i'm asked to: list...

i have created my report that represents an income statement but i do not know how to delete certain fields that do not belong in the income statement, i do...

is it possible to link queries to create a report? if so how would i do this?

I have a form with a command button. If the EndUser clicks the button a report is generated and saved to the hard drive and the EndUser moves to the next...

I have a date form. It has 2 text boxes that pass starting and ending dates to a query to pull appts from that time period. If the report is left open and...

I am running Access 2007 sp2 MSO. I have a report that has three (3) sub reports. There are times when not all three sub reports have values to display. Is...

I have a fairly simple access database. I've created a report grouped by Category and Month... with a total per month. My problem is that the months...