Reports

All Kinds of iPod Mini Accessories
Mini iPod at CircuitCity.com Official site. Free shipping on orders $25 and up or pick up in-store. http://a.uuload.com/Ipod-Mini.htm Mini iPods: Compare Prices Find Bargains on Apple iPod Accessories and other MP3 Players and Accessories. Get tax and shipping information, merchant ratings, and professional pro... 16 Jul 2008 06:49

Slow report
I have a fairly complex report that uses functions, written in VBA, as well as sub-reports. The report takes anything from 30m to a few hours to run. The number of records returned in the main report is not more than 12,000. I removed the sub-reports and most of the function related fields on the main report a... 17 Jul 2008 09:35

How to add Percentages to the detail section of a report
I have a simple Access query that summaries a table based on Year and a field with three possible values. This query: SELECT Year([Hire Quality Data]![Hire Date]) AS [Hire Year], [Hire Quality].[Hire Quality], Count([Hire Quality Data].[Employee Number]) AS [Hire Count] FROM [Hire Quality Data] INNER JOIN ... 16 Jul 2008 09:54

Combining two queries in one report.
Duane; I am having this exact problem and tried to write the Union query in SQL, but I keep getting the error that the select statement includes a reserved work or an argument name that is misspelled or missing. Here are the two queries I am trying to unite: Unscheduled_Production ================ Work_Ce... 16 Jul 2008 14:03

Passing value to Query Criteria from ListBox
Hi. In Access 2007 how can we pass values from a Listbox to a Query as criteria. presently I am using a Command Button to call a Macro which displays Query in Povit Chart View. I want to you a ListBox insted Command button so user can filtered data. Thanks ... 16 Jul 2008 17:11

Count only Not Null fields in report in 2007
In Access 2007, I am trying to count a particular field only when the field is not null, but no matter what I try (have reviewed instructions from several other posts), it keeps returning a count of all records, regardless of content. is there some setting somewhere I might be missing? I've copied and pasted ... 16 Jul 2008 08:51

Break data into two columns in subreport
Hello, Running MS Access 2003 on XP Pro. I have a report that produces a check list. Now, I have a subset of the data for this form that I call the Pre-drive Checklist. I want to compress this section length-of-page wise so I want to break its data out into 2 columns. All the data displays 4 columns, Ac... 16 Jul 2008 14:03

#Error in Calculated control on my Report
I have a calculated control that returns an #Error when no records are found. I would like it to return the following message in the text box instead: "No Records Found." How can I accomplish this. Control Name: TotalVolume Control Source: =Sum([Volume]) ... 22 Jul 2008 13:43

Access 2000 reducing query parameter prompts in reports
I have created several reports in Access 2000 each using several queries/subreports. When I run the reports, I get prompted for query parameters. At this point, all of the parameters that I am asking for are for the same date (the report determines the loss for the plant on [enter date] ex: "7/9/08"), so each... 15 Jul 2008 14:23

Mulitple Query Report
Is it possible to pull data from multiple queries even though they all pull from the same data table and put them all into 1 report? Or do I need to run 1 report for each query? ... 16 Jul 2008 04:46