Over 1 million tech questions and answers.

Solved: Access Report removing sub-report when printing etc.

Q: Solved: Access Report removing sub-report when printing etc.


I have a report, with 3 sub-reports in. It collects all the data for a particular SiteID. in Each of the sub-reports, there is a cost value. One for Hardware, one for Mobiles, and one for Phone lines. I have fields at the top of report which reflects the values and totals them up. Works great, except:
When i have a SiteID with one of the subforms being empty; i.e no mobiles on the site it displays fine in the report view, but when i go to print or publish as a pdf it strips out the subform with no value, and throws an error in my calculation. I need the calculation there, which means i need it to stop striping out the subform with no value. I however cannot see how to do this...its just bugging me, its fine inthe report view, just when you send it to print.

Would grateful for some help,

Thanks Mike

Preferred Solution: Solved: Access Report removing sub-report when printing etc.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Access Report removing sub-report when printing etc.

Read other 16 answers

Problem one, sort order for printing the receipts records.
The way it is it prints each record for each person instead of by Receipt number. The receipt number is the number at the top right corner. These have to print using the receipt number for the print order.

Second problem is the Year To Date (YTD) amount
As it is now each time a new amount is entered for a person it changes all the records for the person's YTD entry. Sometimes they have to go back and reprint a receipt and when they do the YTD amount is the total till present and not the YTR for that date.

If these require Macros or VB please keep it simple, I know nothing about either. I am not sure what I am doing wrong but I need to first correct it and second learn how to do it correctly.

Thank you for all help.

A:Solved: Printing problem Access Report

Read other 8 answers

Dears,I have designed a database with many reports of certain importance. basically a report in my DB is one of two types; a Daily Report (requires a single criteria which is the date) and the second is a History report. To view or print a report, I have designed a Filter form to fill in with the report criteria and clicking a button to open the report.The first type (Daily R) work fine without problems. The second type (History R)has a problem. In this report, the criteria are two or three because a history report will retrieve data within a period, so I have to input (FromDate) and (ToDate)and may be adding another criteria which is called a company.In all history reports, the report header will accomodate the two input values of date and extract the rest of report items into the reprot detail area.The problem is, the desigened system doesnot respond well as expected. When I load the filter form to fill in criteria for a history report, I have input the FromDate and ToDate and selected the third criteria (if any), then, the reprot opens without data in it.on the other hand, I tried to load the report directly form opening it, inputing criteria, and it has worked fine without probelms.Would someone expect a key reason for this problem or dirtecly can solve this problem?Appreciate youtr support.Thanks in Advance.mhegazy

A:Solved: MS Access report load from a form having report criteria

Read other 16 answers

Hi, I'm trying to fix an existing report that prints an extra page inbetween each page of data...what the??

Can't figure it out...help if you can,


A:Solved: Access Report printing extra page

Never mind...figured it out...data wider than page width...duh!

Thanks anyway!

Read other 1 answers

I have spent all day fiddling with this and getting nowhere. I have a report in Access 2007. It's very simple - just orders placed which I want to send to be printed as a PDF. On screen in the report view it all looks perfect, with orders which involve more than one item showing as they should. However, when I send it to the print preview the detail section disappears and is split across 8 or sometimes 9 pages. I had it working fine (briefly) and then had a go at including a field to total the costs of multiple orders and it's all gone to hell in a handcart since then. I've got the detail section and the controls within set to 'keep together' but nothing so far seems to make any difference. I'd be grateful for simple help as I'm a novice when in comes to coding. Thanks in advance.

Info re my computer:
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 2986 Mb
Graphics Card: Intel(R) HD Graphics Family, 1024 Mb
Hard Drives: C: Total - 750003 MB, Free - 519898 MB; D: Total - 197870 MB, Free - 152844 MB; X: Total - 114442 MB, Free - 18524 MB;
Motherboard: ASUSTeK Computer INC., P8H67-M
Antivirus: Norton Internet Security, Updated: Yes, On-Demand Scanner: Enabled

A:Solved: Access 2007 problem printing report

Read other 16 answers

I have an Access database that is holding key dates. I need to produce a rather complex report and have tried several variations to no avail. Basically it incorporates core information, court date (of which there can be many) and Other Dates (of which there can be many). I cant get the court and other dates to show without duplicating either the column headings or the core data.

Please see attached. Can anyone help?

To see the report:
1. Click Produce Key Dates Report on the Main Menu
2. Enter the dates 01/01/07 to 01/01/08
3. Click Search

A:Solved: Removing duplicate info in Access Report

Read other 16 answers

I have a very simple data base 3 tables

Product table with 2 fields productid and productdescription

Sale1 is the basic information of a sale invoice number and who items are sold to

Sale2 is the details and shows qty , item, price, and GST charged if any (some people or organizations are tax exempt so it becomes zero.

I've got my form and subform to run correctly

I've got my report to print all items correctly but I can't total the value

the line value for each item is a textbox

=Sum([QTY] * [Saleprice])*([GST])+([QTY] * [Saleprice])

This does return the correct value for that line item.

HOW can I correctly total the sum of all items into the reporrt footer???

HELP please the sale is tomorrow through Sunday.

A:Solved: Total in Report Footer ACCESS 2010 Report - Total NOT working

Add a duplicate of your current calculating field and set it's "Running Sum" (under data tab) to yes overall.
Then in the footer use the new field as the totals Control Source.

Read other 2 answers

I have been working on a particular Access database for about two years, and it has been what I needed, however in October I ventured off to change the way the way I had to 'jump through hoops' to get a final report printed. I posted my delimma and OBP worked me through the "MAJORS" of my issues. My LAST issue with this report is this: there are blank pages printing between the 4 subreports that I have inserted. Everything else works perfectly, but I have tried over and over agin to do what I have read in the "MS Access help menu" to no avail. Can someone PLEASE help me? I know the answer will be a simple matter, but I just can not figure out what is wrong.

Thanks in advance

A:Blank Pages Printing in Access Report

Read other 10 answers


Read other answers

I have a HP Officejet 6210 All-in-one printer. All of a sudden, the printer started printing a report after it finished printing. The report includes the Directory, template, tittle, author, creation date etc. . . This report is eating up paper, and I hope someone can help me resolve this proble.

PS I posted this question a month earleir but was not resolved.



A:Solved: printer keeps printing report

Read other 6 answers

I am using Access 2003 and want to put the file (database) name and the report name in the footer of my report. I'm using =CurrentProject.Name as the control source in a text box of the footer to get the file name. Is there a command I can use to add the report name?

A:Add report name in Access report footer

Hi Trilby

You could try this:

In the VBA code module (Class Module) for your report write a simple function (I've called it Get_Report_Name in my example):

Private Function Get_Report_Name() As String

Get_Report_Name = Me.NAME

End Function

In your report footer: add a text box at the position where you want to display the report name. In the Control Source property for the new text box enter: =Get_Report_Name()

This should display the report name when the report is run.


Read other 2 answers

Hello, I am using Access 2000 and have created a database with a command button that opens up a report via a macro. I would like to know how to open up single reports instead of pushing a button that brings up every report, I've been able to open up reports that are based off of queries, queries that have paramenters that need to be inputted in order to bring up single unique records, but I would like to be able to just create a button that brings just that particular unique record-report off of that particular unique record on that form. Meaning that for a record that had just been inputted for John Doe on a form, I would like to know how to create a button on that form to pull up John Doe's single report without having to build a query that asks for a parameter. Is there anyway to do this?

A:Access-Printing a single report off of a single record from an Access database form

You will have to adapt this to your own form setup; but it's just using the Where line of the OpenReport macro action.

If on the form MyFormName you have two controls called txtFirstNm and txtLastNm, and in the query underlying the report you have two fields called FirstNm and LastNm, you would put into the Where line of the OpenReport action:

[FirstNm]=[Forms]![MyFormName]![txtFirstNm] And [LastNm]=[Forms]![MyFormName]![txtLastNm]
Hope that helps.

Read other 1 answers

I am trying to print a report based on a selection made on a list box, but I cannot seem to get it to work. The code below is what I have behind a command button.

DoCmd.OpenReport Me.lstReports, acViewPreview

Is there something I missing with the code above?

A:Solved: Access Report

Create a Command button to open one of the reports and then chnage the code that says
"stDocName = "USDA New Families Report""
stDocName = me.lstReports
Assuming that me.lstReports is the name and not the List Index value.

Read other 2 answers


i have just created a report in access 2003. In design view of the report everything is perfect and shows correctly, but when in preview mode nothing shows in the "Details Section" this is really weird and i cannot figure it out.

Can somebody help me please? Thank you for your time.

A:Solved: Access Report HELP

Read other 9 answers

I have an access report that is designed to print on label paper. I added 4 sets of the fields I want but isntead of the 4 sets showing unique records they all show the same records. Is there a way that I can have the report only display unique records in the box.

| | |
| | |
|_same _|same__|

and I want

| | |
| | |
|_DIFF _|Diff__ _|

A:Solved: Access Report

I have not done labels on label paper, but I do not think that you should add the Fields. I think that there should be just one field.
I do know that you can achieve what you want by using one field and with the Report in Preview click Setup>Columns. You can then set the Columns to 2 and set their width to suit your labels, the "Depth" of the Record Detail on the report will position the fields down the page.

Read other 3 answers

I have an Access report that I would like to seperate by the month. On the report, I have a date type field that I would liek to use to seperate by months. I then would like to take an average based on a certain filed for each month.

How would I go about doing this?

A:Solved: Access Report

Read other 14 answers

I have an Access Table that contains two date type fields. Sometimes one date field will have data and the other will not have any data. Other times they will both have data.

I need a way to display both date fields on a report without having two different fields on the report. What I would like happen, if the second date field is blank/empty/null then display the first date field. If they both contain a date, then display the second date field.

I tried placing a textbox on the report with the following:

iif(Datefield2 = "", Datefield1, Datefield2)

That did not work. Can someone please guide me in the right direction.

A:Solved: Access Table and Report

Read other 14 answers

I have a form open with all the details i need, and i can email a report, using the code below, i just cant get it to email the report that is open for an individual "DevelopmentID". I just dont know how to link the "DevelopmentID"

Private Sub CmdEmail4_Click()
On Error GoTo CmdEmail4_Click_Err
DoCmd.SendObject acReport, "RptClientAll", "PDFFormat(*.pdf)", "", "", "", "All Client Detail", "", True, ""

Exit Sub
MsgBox Error$
Resume CmdEmail4_Click_Exit
End Sub

Any body got any sugestions please? The normal Macro does not link, so im resorting to VBA. ive converted the macro to show the VBA as above. Ive tried different ways like below, but it does not link it still:

Private Sub CmdEmail4_Click()
On Error GoTo CmdEmail4_Click_Err

DoCmd.SendObject acReport, "RptClientAll", "PDFFormat(*.pdf)", "", "", "", "All Client Detail", "", True, "", "[DevelopmentID]=" & Me![DevelopmentID]

Exit Sub
MsgBox Error$
Resume CmdEmail4_Click_Exit

A:Solved: Emailing a report using VBA for Access

Read other 9 answers

In a report that I just finished there is a small change I need to make and I can't find a way to do it. I have a field (Period) and I used it as one of the grouping levels during setup with the wizard. The values of this field are 30 days, 60 days, 90 days. The problem is that on the report the order is backwards listing 90 days, 60 days, and 30 days. The problem is twofold, I can't figure out how to get back to the wizard without starting a new report and even if I do, I didn't see a way to change the sort order on the grouping levels - as the fields that are grouped by are removed from the sort order dropdown box. How can I change the order?

A:Solved: Access Report Question

Look in grouping and sorting options and change the order to descending.


Read other 2 answers

I just purchased Office 2007 so that I could e-mail reports as pdf files. This works fine and what I actually e-mail is a portion of the report as defined by a where clause or filter. When the report goes out in the e-mail it uses the report name as the file name i.e. "rpt R1 .pdf" The commands are in vba and are initiated by a button on a form.

Since I am only sending a portion of the data (e.g. item number 1234) and since I am sending the report because I have updated the data I would like my file name in the e-mail to be more descriptive. What would be good is a file name of "1234 revised 4-19-2007.pdf". Does anyone know how to do this?

The only way I have thought of is to use a DoCmd.CopyObject (or rename) to create a copy of my report object with the name "1234 revised 4-19-2007" and then run that and then delete it. I am pretty sure this could work but I feel there might be a better way.

A:Solved: Access Report VBA Question

The solution to this is to first save the report output to a (pdf) file using the a command similar to the following:
DoCmd.OutputTo acReport, stDocName, acFormatPDF, stFileName
and then send an e-mail with the file as an attachment. This cannot be done with DoCmd.OutPutTo but can with a custom subroutine (free) from Peter's Software. Here's a discussion of the issue http://www.peterssoftware.com/c_emfa.htm and a link to the sub. It worked for me: http://www.peterssoftware.com/c_som.txt

Read other 1 answers

Using Office XP


I have a report that runs on a query. This asks for a date to be entered then the report lists all records that match.
On the report the date entered is shown but as the date is entered in the "dd/mm/yy" format this is how it is shown.
Is there a way that the report shows the full Day and Date eg. Thursday, 01 October 2009.

A:Solved: Access Report - Dates

Read other 7 answers

I have created a report in Access 2003. I would like for the report to display the data in columns. I have went to File -> Page Setup -> Columns Tab. I changed the number fo columns to 2, but when I view the report there is still only one column an dthe remaining data is not visible.

Does anyone know how to fix this issue?

A:Solved: Access 2003 Report

Did you set the column widths?

Read other 3 answers


I have a report in Access 2003 that I am basing off of a query. I would like to use grouping in the report. For some reason, when I open the grouping box, not all the fields show up from the query. Does anyone know why this is?


A:Solved: Access 2003 and Report

It may be that some fields do not contain the correct data structure to be able to be used for grouping.

Read other 3 answers

Hi, i have a report that shows unpaid invoices. I have a problem getting the total of all upaid invoices. I use this expression in the reports footer =sum([total])

The problem i have that it is only showing me the total of the last invoice not the total of all invoices.
any help will be appreciated.

A:Solved: Access Report Expression

Read other 10 answers

Good morning. I found this forum this morning and I hope someone can help me out. My company is looking for a report that will list purchase orders and invoices paid against them. The PO amounts and invoice amounts are housed in the same table but in separate columns. There are multiple invoices paid against every PO. In order see which invoices were paid on each PO, there is a column for PO number. The PO number gets entered in on every line. I have tried to set up a query that will deduct the invoice amount from the PO. The problem I am running into is when the query runs the PO amount pulls in for every time an invoice is paid against it. For example PO123 is $30,000 and the following invoices are paid against it: INV 3 - $5,000, INV4 - $5,000 and INV5 - $5,000. The query will return $90,000 for the PO amount and a cumulative total for the invoices of $15,000. What do I need to do? Any help would be greatly appreciated. Thank you.

A:Solved: Access 2007 AP Report

Read other 16 answers

I am using the Student & classes template to record student grades.
I am trying to figure out how to print a report card per student. As yet all i can do is print a list of all teh students grades & classes all together. Is there a way to print a report that is baseed on a particular record i.e. the student ID.
Thanks in advance

A:(Solved) MS Access Report/per record?

Read other 12 answers

I am having a problem with an Access/Outlook data transmission. I need to send an access report, as well as an external file, to various users using Outlook. I can send the report using the docmd.sendobject method, but I need to send the external file (an excel spreadsheet) in the same e-mail. I have found I can send the excel file via adding it the the attachment collection, but haven't been able to add a report to the collection. This (the second) is what I would prefer to do if it is possible. Any help is greatly appreciated.

A:Solved: Access Report via E-Mail


Read other 1 answers


I have a Vat Report and a Turnover Report. On each report i need to get the total but i keep getting #Error.

I created a text box in the reports footer and set the control source to =Sum([Vat]) an changed the running sum property to over all but i keep getting #Error

I have looked everywhere but cant seem to get it working, i hope one of you will help me out.

Thanks in advance.

A:Solved: Access 2003 Report Help

Read other 6 answers

Getting my butt kicked here, I'd appreciate any help.

I need to add a field in a report to show a voucher number. It needs to start at a certain number and +1 everytime the report is ran. Not talking records here as every google search I've found deals with records.

Example: I run the report today and the field says it is 33. I run it tomorrow and the field says it is 34.

Any ideas would be helpful.


A:Solved: Access 07 Report Numbering

You need to store the last number used someplace.

Are you current storing the last number used?

Read other 3 answers

Ok all, bear with me. I have created a simple database that holds agent statistics for a daily scorecard. There are 6 different types of employees and each type has a certain criteria to meet.

I.E. - An entry level employee must meet a quota of 8 calls per hour (CPH), If he/she meets it then they "Meet Expectations" if it is below then they "Need Improvement"

I have a report tht lists all employees, their employee type (entry, intermediate, advanced, etc) and their "CPH".

I would like their CPH to be color coded based on meeting criteria or not. It would be easy if they all had to meet the same criteria (I would use conditional formatting)but since there are 6 different types, is there a way to write code for this.

Example in plain words:
IF "employee type=entry level"
Then follow these guidelines to color code values.

I know this may be choppy so let me know what detailed information you would need from me. If you want to really help I wouldn't mind sharing my db by email and having you take a look, it is just a very basic database.

This is the code I have so far, i am very new to VB and am not sure if this is correct. It compiles just fine, and I can open the report after saving this code, but it still does not work. Got any ideas???

Here is what i have so far...let me know what questions youhave or if there is anything you need to help me out. Thanks
[SIZE="3"]Private Sub Detail_Format(Cancel As Integer,... Read more

A:Solved: Formatting Access Report with VB

Closing duplicate, please reply here:



Read other 1 answers

I'm using ACCESS 2003 and I created a query named 'Key Measures - BESOS' with the criteria set for [Date] as a parameter ('Between [start] And [end]') and it works fine; however, when i run the report based on that query i get an error (#Error)message in all my fields. The report looks at the sum of cases that meet my criteria in several fields. for example, i need to know the sum of cases that are outreach (1) and have the following formula: '=(DSum("[outreach"],"Key Meaures - BESOS","1")*-1).

All the formulas used to work perfectly before I set the criteria in the [Date] field in the query. Why is it that my query is running fine, but the report isn't? I've checked the Record Source and it is OK. I don't know if this is relevant, but the fileds are in the Report Header section to avoid getting 50 pages with the same info. Again, everything used to work fine until the date criteria thing and i didn't change anything else.

please help me, i'm about to quit my job

A:Solved: ACCESS report error

Read other 7 answers

I have created a db that keeps track of employees time worked and leave taken.

I need help getting the time worked by employees to calculate/total on a report. I would like for the time to be totaled for the week, and then again for the month for each employee. The db is setup so that there can either be a manager or non-manager employee. If the employee is a manger, then they have two options when it comes to viewing reports. They can view his or her own report with just the time worked, or they can view all employee's time worked. The non-managers can only view his or her own time worked. The other kicker is that the employees are either salary or hourly. If the employee is salary, then they do not have to clockin and out for lunch. The hourly employees do have to clock in and out for lunch.

I have attached a copy of the db. Any suggestions or guidance will be greatly appreciated. If any further information is needed, please let me know.

A:Solved: Access Report Issue

Posted this thread twice by accident. Please see thread that has not been marked solved.

Read other 1 answers

Iíd like to know how, if possible to do in Access, a calculation:

I have a 30,000 lines of data. Each line contains, amongst other stuff - a Sitecode, ItemCode, date, value and flag.

Each SiteCode can be categorised by itís prefix letter A,B,C
ItemCodes are TSGxx where xx is 01 to 99

The Flag only appears when a certain value is exceed, but as far as where Iím taking this Ė we neednít give further thought to the value as the flag is coded in the data.

My question is, is it possible for Access to report/query on the percentage % of each code (A,B,C...), The ItemCodes that have been not been flagged

Have attached sample excel for which the data is to exported to Access.

A:Solved: Access, a calculation/report

Read other 7 answers

My boss wants me to make my db so that it exports a report to excel which is not a problem but, he wants the excell to be formatted like the report which displays doubled up headings and doubled up data so that it all fits on letter sized report I think maybe I can make an excel template to output to?? But is there a way to reformat and excel doc to double up the headings and make it my template? Anyone ever done this?

Thanks, Joe

A:Solved: Excel report from access

Does not look like this is possible

Read other 2 answers

I have a report that is displaying a number field. I want to sort on the report by the numbers, but the sorting is not working properly.

For example, I have numbers: 1,2,3,4,5,6,112,200. Here is how the report is sorting the numbers:


Why will it not sort in a series?

A:Solved: Access 2003 Report

Read other 16 answers

I'm trying to generate a formula that will tell me the Median outcome from a query. Is there a standard formula for Median in Access?

If the results of my query (for example) are 1 through 100 rows, I want the formula to count the number of rows, divide by 2 and tell me the value of a particular field in the middle row.

Hypothetical example:

Count of [ID#]=100/2 tell me the value of [Amount] in row 50

Not sure if this makes any sense to anyone but I'd appreciate any help.


A:Solved: Access Formula in report

Paintergrrl, you are the first person to post on here who actually wants a Median value for real, why I don't know, because to me it is a pretty meaningless value.
Access doesn't have such a Function, although it has quite a few simple Statistical functions.
So it will have to be done as you have outlined, you can obtain the record count either in a Query or using a VBA Recordset, but to get the Median Record you have use to use a VBA recordset.

Read other 1 answers

I have created a report in Access 2007. The table that the report is based off of does not have any duplicates. However, my report is showing multiple duplicates. My report is grouped by Provider Name with a title header. Then in the detail section of the report I have the following fields: Measure, Member name, Member ID, Address, City, State, Zip. Since the report is grouped by provider, the member could have different measures listed by their name. In which case, I would expect to see them on the report more than once. However, the report is currently showing multiple members for the same measure; therefore, resulting in duplicate information. How can I get rid of the duplicates in the report?


Read other answers

I am pulling my hair out...

I have data related to forestry surveys on individual parcels. Each Parcel has many plots and each plot has any number of Residuals, Seedlings, Groundcover and Shrub records (each in their own table). The relationships are all set up and I haven't had any problems until now. I have a form that includes a combo box that uses the (unique) parcel ID numbers to open a report for that parcel. The report contains four subreports, one for each table (residuals etc.). It looks like this:
Private Sub List35_Click()

DoCmd.OpenReport "test", acViewPreview, , "[PARCEL_ID]=" & "'" & List35.Column(1, List35.RowSource) & "'"
End Sub

My problem is that for SOME parcels, the report opens fine. For other parcel IDs, however, it opens a blank report. As far as I can tell there is NO difference between records that show up and those that don't.

I'm not hopeful anyone will really be able to help since it seem so random but I thought I would give it a shot. Thanks.

A:Solved: Access Report Missing Data

Read other 14 answers

Hi guys...

I have a database that has 2 tables.Table A is the "master" and is linked to Table B with an ID and this has transactions in it. Table A has a field for departments. Table A also has a priority field of 1-4 or it's blank if it hasnt yet been set. Table A has a comment field called X.

I have a report that currently prints Table A (with a simple query to ask the lowest priority required to print) including all the transactions associated with each record in Table A. The report is printed grouped on departments.

What I'd like to do is in the department footer include all records for a department from Table A that do not have a priority but DO have something in field X.

Is this possible or is it the impossible dream?


A:Solved: Report in access ton include certain info

You can do most things with Access.
It sounds like you need a query to find the correct data and then create a Report from that.
Add the Report as a Sub Report to the original Report's Footer, ensure that no Master/Child links are set.

Read other 2 answers

I am trying to produce a report in an outline format as follows:

Employee Name
Employee Name
Employee Name


Heading 1

Heading 2

There may be more than 1 employee doing a particular service for a client. They each input their service seperately as a new record. I need to be able to pull out the information for headings and subheadings to display as above. I also need to be able to pull out the information associated with the client. My fields are Department, Employee First Name, Last Name, Client, Heading, Subheading. How do I display this in a report. Have tried many options. Please Help!!

A:Solved: Access 2007 Report Formatting

Read other 15 answers

I know my way around Access enough to create simple things, so I need some help with a report.

I have a database to track employees along with their hours worked, hourly rate, along with mileage and mileage rate. I have one table with the employee information only. I have a second table with the information for each week where the information is entered for hours worked, hourly rate, mileage and mileage rate.

I have two reports setup so that I can run a summary report showing all information by each employee, sorted by week end date. I also have another report based on just a summary of YTD wage total for each employee.

I don't know if this is even possible, but I would like to be able to, through a switchboard, to be able to have a detail report run on one employee only. Ideally I don't want to go in and set up a report for each person because the people change. Is it possible to use a combo box somehow so that when you select the employee's name, the report is generated for that employee and to be print only? And have that through the switchboard?

If this is confusing I will try to make more sense, or provide additional information.


A:Solved: Access 2003 Report by Selection

There are many ways to do this.

One of the simplest would be to set up a swithcboard form as you've suggested
let's call the form"


Now on this form, you can place buttons for running all your reports.

Now on this report you put a combo box from which you choose tht name fo the employee. Lets name the combo box:


Now take your existing report that currently runs for emm employees and make a copy of it that will be used to run for just one employee only.

In the regular report (for all employees) the data source might be something like
SELECT [tEmployee Data].[Emp Name], [tEmployee Data].[Emp ID], [tEmployee Data].[Emp Department], [tEmployee Data].[Emp Etc]
FROM [tEmployee Data];

Now in the copy that you want to run for just one employee, you introduce a where cause in the data source that uses as its criterion, the value of the cboEmployeeName combo box:
SELECT [tEmployee Data].[Emp Name], [tEmployee Data].[Emp ID], [tEmployee Data].[Emp Department], [tEmployee Data].[Emp Etc]
FROM [tEmployee Data]
((([tEmployee Data].[Emp Name])=


Note that if you try to run the report when the fEmpReportSwitchboard form is not open, you will get an error.

Read other 3 answers

I have a query that lets the user search by date range and returns all records where the value in the data received field is between the date range or is null. The problem is that the date is entered on a form after some of the other info has been entered on another form and the info has to be entered this way and the records have to be on difference rows in the tables. So on the report the date shows up on a different line than the rest of the info, how can I combine the two rows on the report so they show all on the same line? Please help. Thanks.

A:Solved: Access report/query question

Read other 15 answers

Hi, I hope you can help. I have a report with a subform. In the subform the user can select months from a dropdown list which are then displayed. I then have a report which displays these months. The months are in the detail part of the report. However the report displays the months upside down. i.e December, June, January. I would like them to be displayed January, June, December of course! I look forward to hearing from you. Thanks Richard

A:Solved: Upside down results in Access report

Read other 13 answers


First time poster so please be nice . With that out of the way here is my question:

First some background info to help understand the problem:
I am have designed a report in Access 2007 that displays a list of programs on what servers they are installed (if any) and where they are missing.

CountyName ProgramName ProgramVersion Size
County1 BlackHole.exe 1072KB
County1 DirtFarm.exe 1072KB
County1 PlayGround.exe 1072KB
County1 Gremlin.exe 1072KB
County1 Water.exe 1072KB
County1 Hydrogen.exe 1072KB
County1 JustInTime.exe 1072KB
County1 RogerRabbit.exe 1072KB
County1 SuperMan.exe 1072KB
County2 Hydrogen.exe 1072KB
County2 JustInTime.exe 1072KB
County2 RogerRabbit.exe 1072KB
County2 SuperMan.exe 1072KB
County2 Ironman.exe 1072KB
County2 Gorgon.exe 1072KB
County3 BlackHole.exe 1064KB
County3 Astroid.exe 1064KB
County3 Galaxy.exe 1064KB
County3 SpaceMan.exe 1064KB
County3 Clouds.exe 1064KB
County3 Green.exe 1064KB
County3 Ground.exe 1064KB
County3 DirtFarm.exe 1064KB
County3 PlayGround.exe 1064KB
County3 Gremlin.exe 1064KB

what I would like is a way to use conditional formatting on the report to highlight any Program version in red where the program name is the same as County1 but the Program Version i... Read more

A:Solved: MS Access 2007 Report Question

Read other 6 answers

I am trying to get the report in Access 2003 to open maximized and at 100%.

If I use the code:
The report opens maximized as it should be with a property of 'Fit".

I tried use the code...
DoCmd.RunCommand acCmdZoom100
but I get the following error message "The command or action 'Zoom 100%' isn't available now."

All the codes have been entered in the Report_Open event procedure.

Any suggestions?

A:Solved: Access 2003 and Open Report

Read other 10 answers

Hi all,

I'm trying to create a report based on a small database of info imported from Excel. What I want to do is have the report totalled by month. I created a new field for the main table with an update query that added just the month name (don't know if I need that to total by month or not, there is a date field as well). I've uploaded the database to give a better example.

What I want to end up with is a report that shows a Monthly total for each Source in the database. There are five sources, so this should be 60 different totals. There is a field in the database called 'galTKN', this value should appear in that summary as well. The value will not change and is the same for every record. I was debating creating an extra table for this, but it could change in the future.

Let me know if you need any other information. TIA.

A:Solved: Access: group by field in a report

Read other 6 answers