Recent content by DBDUDE

Thanks. Yes, I think the lines are too wide as well. The problem is that when viewing the reports, I do not see the lines. Is it something about my settings or view? Also, is there a way to automatically force the report to be a certain width, and then have Access cut off everything past...

When I view my report, all the contents fit on one page. The next few pages are blank and only have lines on them that extend horizontally for no reason. Is there a way to force all elements of the report, including graphics, to be a speficied width? Thanks

Yes. I want this to happen while running the report. Do I need to take care of this while in Design View?

I am creating a report and playing around with the formatting. Every time I change a Field in the Header section, I want to automatically change the Detail field that corresponds to the label. For example, if I change the size of a text box in a Header section, I want the detail that the text...

I do not have a report named "Summary Options" (the thing that Access says it can't find), nor do I have any fields in the query or the report called "Summary Options." Any suggestions about how I can debug this error? Thanks

And how to debug it? Thanks. Not sure what other info to include... The expression On Format you entered as the event property setting produced the following error: The report name ‘Summary Report’ you entered is misspelled or refers to a report that isn’t open or doesn’t exist. · The...

I have a report that is Grouped by Department. Each department section has several copiers under it. Various data about the copiers is displayed, including a billing total for each copier. I need to sum the Billing Total for each copier in a specific department and then display that amount...

Hi. I'm designing a database that will generate monthly invoices for 500 customers. The customers all rent copy machines, and each month we get an Excel report which lists the number of copies made at each copier. My first step is to import in all data, including the static information...

That did the trick, thanks much!

Hi. I am using Expression Builder to total 3 columns for a query. Total: [BaseTotal]+[ClickTotal]+[Adj Total] The [Adj Total] is sometimes empty, and when this happens, Total is empty even though there are values for [BaseTotal] & [ClickTotal]. How can I make the Total show up regardless...