I have been using the following code from Allen Browne to select a random percentage of records on the open event of an unbound report. Private Sub...

I have a report which shows 2 columns in the main report. Then I have a subreport that I show in a grouping footer that is a 1 column subreport, but becuase...

All, I have a report which is currently sorted by a numerical field, i.e. 1,2,3, & 4, as in a priority ranking. Is anyone aware of an option that will...

I have a series of 3 reports that make up a weekly report. Manager wants to be able to push a button and export all 3 reports into a "single" word document so...

I have a report that I need to list totals by month by there account code & sub account. I have a query that generates all the necessary information but I am...

I have a database for tracking miles traveled and fuel purchased in each state. I have a report based on a query to total miles and gallons for each state...

Here is My Data in Category Item ======== ========== Fruit Apples Fruit Oranges Fruit Bananas Nuts Peanuts Nuts Cashews Nuts Almonds

Is there a way to display the actual records that are being imported from excel to access if they continue giving you an error message?

I think I've found a bug in MS Access reports from Oracle databases. I've searched the knowledge base and did not find any reports of this issue. I have two...

Hi, I have a report that is grouped and prints the group header on the first page of each group. There are multiple pages for each group. How can I get the...

I am trying to set up a report which will only lookup the last four records and average the data from only the last four records. Records will be added to...

How can I isolate the expression/calculation that is causing this error?

When I print Access reports some take paper from bin 1 and some take paper from bin 2. I want all reports to take paper from bin 1. How do I achieve this? --...

I have a text box that has a running sum of totals set up like this =nz(Sum()) Under the conditional format I have it set up that if the field value is less...

I have a totals query that looks like this: SegmentID LandCost ImpvCost Damages Relo Incidental Demolition 001 $ amt $amt $amt ...

my report has a lot packed into the Detail section of each page. It would be great if I could print a horizontal line after every 3 records. What's the...

I've got a sub-report that is pulling information from a related, but different table from the main report. The master/child link is correct, I've checked...

I have a report which forces a new page each time the section footer is printed, but I need to suppress the final page because it is always blank. Is there...

Hi.. I need some help how can i get the number which is shown at the Navigation Buttom at the bottom of the form in a report with other fields??? Is it...

Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has...