I have 6 queries that I want to use some data from each. Each query is based on a table that has different types of products and each has an amount column. I...

I use the following code in an unbound text box on a report to extract all unit records from a query and then place each subsequent entry on the next line, and...

In report wizard, I want my column order to be differet than my sort order. Hoiw do I do this without having to go to the redesign window?

I have a report that is filtered by a form. I need to be able to get a count of the total amount of items in the table including what is being...

I have a report that has 2 pages in it and runs from a command button. I need 2 copies of the first page and 1 copy of the second. Is there an easy way to do...

I am working with certified payroll reports and a report needs to be generated for each week, even if there is no data. The report which does have data, has an...

Hi Is it possible to create Drill-Down reports? Whereby the reports are Grouped to show summary values, but can see the data behind those...

Hello All I have a report that is based on table . The table includes the following fields: (integer) (text) (integer) First of all, I should say that I...

I use a form to make a "working model" for a form that has pie charts. Due to what is required by me form my higher-ups, the want labels with leader lines on...

I am working with a database that supports the recording of events/times for school athletic competitions. Currently the "marshalling record forms" for each...

I have some trouble setting the size of the footer section and the details section. My header section contains order information (i.e. name, adress etc)....

I would like to NPV some cashflows in a report. Is there an easy way to do this?

Hi, I'm creating an Access 97 database in which I want the "Allow Full Menus" command under startup to be disabled. My problem is when it is disabled and I...

Can anyone give me the formula that ensures that in an address list, where some addresses have more lines than others, the blank lines are not printed? I would...

(using WindowsXP SP2) Access 2003 was happily designing and running reports through the UI, and running them through automation (using .net framework v2). ...

Hello All, thanking anyone for a reply. A97. Have a problem with the event in NoData for a report based on a query with two tables. I have put code in it...

Hi, I am trying to get the OpenArgs on my report to display Yes or No instead of -1 or 0. I have an unbound listbox on a form with its Row Source property set...

How can a generate a report that repeats the detail line based on another field in the table.. for example if accounts = 10 I want to produce the same detail...

Greetings, I have a report data sourced by a query. The query looks at two tables, one of which holds the main identification records (which aircraft) and...

Hi all, I am trying to build a report using "Create report using a wizard" option. I have built a query which is based on different tables and when I run...