I'm trying to use dlookup in the control source of a text field in the header section of a report. If I used a query to get the result it would be this: select...

i have one form where i enter patients data and expenses. and i have three reports to be printed for it.one for ticket LPO , one for advance payments , and one...

If the numeric field in a report's underlying query = 47, I want the report to print "Los Angeles." If the field says something other than 47, I want the...

I have a report with columns and headings, and a sub-report that displays the detail for these headings. When the detail does not need more than one column, it...

I have numerous drop down boxes in a "Student Input Form" that get their values from the table 'Students'. When I move to the next record, the drop down boxes...

I would like Access to Create a Random Number (eg 1132GH667UIIP) for a student ID tag, that creates this once a day if that record is opened. This for for...

I am having troubles trying to create a sum in a report. I have a report that is grouping on different divisions. I have made some calculations in each...

I have a report that I must count the number of check boxes in the on position or the is not null. I used the "= Count ()" below the footer but it counts all...

My company has 5 branch offices. Normally if I were to create a report and list the people in each branch i would group on branch and all the people would be...

Hi guys! I've trying to create a report based on a query which displays a person's details. But I want the report to start on a new page for when it comes to...

This is a repost as I got no result with the previous suggestions I have a report in which I want to summarise how many people are qualified. the report lists...

Hi, I found a bug in MsAccess 2003. I have enclosed the database with the report and the query. And also the procedure (word.doc) to get the error. What I...

Dear all, I have a small application designed for a friend written in Access. My problem is: I have a subreport and a main report that set any field with...

I have a report that asks the user for a processing date. They would enter mm/01/yyyy and the report would be generated. However, if that is an invalid entry...

I have a report in which I would like to include 95% confidence intervals that are calculated using software outside of Microsoft Access. Currently, this...

I have a report grouped by CustomerName like this: -CustomerName Header Section- CustomerName DetailLabel DetailLabel DetailLabel -Detail...

Hi, I found a bug in MsAccess 2003. I have enclosed the database with the report and the query. And also the procedure (html) to get the error. What I...

Hello I have a sum field in my report footer. With an access back-end it would sum total all of the records in the filtered report. Since upsizing it no...

The current default for a weekly report on Access is Sunday through Saturday (I think). How do I change the weekly reports to pull up Monday through Sunday.

I need to print a report that produces varying numbers of rows on an index card template. There is a single column of three cards to a page. As I said, the...