I have a report using a query that contains a "total" field that is summed. My report is grouped by "customer", showing the customer name in the group header...

I created a dialog box(form) where users specify criteria for filtering a report by picking choices from a multi-select list box and an option group. The form...

Following is an example of my query records(there are actially several other RL's and Actual, BT, N and S fields in the query. This is a sample): RL,...

I've been working w/ my report for a few days and all of the sudden I'm getting this error when trying to run it. I do not get the same error when running the...

In my report control, I'm trying to show a value of the Password field in the InstructorsLogOn table where the System field in the same table...

I have several labels in my report, check1, check2, check3, etc... I need to hide these labels if the field does not equal "Module". How can I write code...

I am having problems setting up a report. I've used the instructions in article Q210044 to Print Labels on the Left Margin of a Report, which worked great for...

I have the following CrossTab query that works great. I have a chart with the data source as this query. Even if a user types 1/1/04 - 12/31/04 and the query...

On the one my report the page number is working good. ="Page " & & " of " & But, the another one that is almost the same as previous is showing #Name? Could...

Hi everybody, I have small database and I using OLE objects in tables because my text is more than 255 symbols (using excell spreadsheet). The problem is when...

After installing Windows XP instead of 2000, I've got a cut chart in a report. The chart is based on days per months. Now, it shows only 26 or 27 days instead...

I'm trying to show on my report the names of the last 6 months. When I use this =Format((Year(Date()),Month(Date())-6,1),"mmm") for the 6th before current...

I have a query with many columns. Some of them are Product Territory Distributor Broker Country Qty1 Qty2 Qty3 ... In addition to creating a report with...

Hi, I have a report that is run from different queries. On my Form, I want to put a check box, which by checking it, it will cause one of the queries of the...

How could I check from VB a number of pages in a report to alert a user before printing if there are many pages? Thanks

Is there a way to have a "look up" for a parameter in a report? The parameter is set in a query by , which will prompt the user to enter say an account number...

Hi I have a report which lists surnames and which runs to about 20 pages. Is there anyway to put a count at the end of the report to count the number...

Hi I have a report based on a query. All I want to do is onthe report, display the total number of records within the query. Can someone tell me how to do...

I want to print a report from a form. Report and form have same quite complex recordsource. With Reports!Myreport.recordsource= Forms! MyForm.recordsource set...

I have a query with a text field called TermDate with entries like Jan/04, Feb/04, Qtr 1/04, Qtr 2/04, etc... The TermDate field is a text field and I've...