Problem to print the value of a parameter on a report?

christian

Hi everyone,

I'm trying to print 40 timeSheets for a given Pay Sunday. The problem
is that the query prompts the user(me)to enter [Enter EmployeeNumber]
and [Enter Pay Sunday, but it doesn't open the report, instead it
keeps asking 40 times those parameters.

I want to be able to enter the given[Pay Sunday] and see everyone's
timesheets,so I can print them at the same time.

Does anybody have any suggestions?

Thanks in advanced.

Nov 13 '05 #1

Subscribe Post Reply

1146

PC Datasheet

First, you need a query that returns the data for all 40 timesheets. Then
you need a timesheet report grouped on EmployeeNumber. Put a page break
(found in the toolbox) at the bottom of the detail section of your report.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"christian" <cs********@partners.org> wrote in message
news:e1**************************@posting.google.c om...

Hi everyone,

I'm trying to print 40 timeSheets for a given Pay Sunday. The problem
is that the query prompts the user(me)to enter [Enter EmployeeNumber]
and [Enter Pay Sunday, but it doesn't open the report, instead it
keeps asking 40 times those parameters.

I want to be able to enter the given[Pay Sunday] and see everyone's
timesheets,so I can print them at the same time.

Does anybody have any suggestions?

Thanks in advanced.

Nov 13 '05 #2

Similar topics

Crystal Print Problem

by: Randy | last post by:

I'm using Crystal.net version 9.0 in a aspx page using the CrystalReportViewer server control. When I view a report running locally on my server where I installed the crystal off the CD, the...

.NET Framework

MS Access front end to SQL Server problem passing Form value to Report

by: rickcheney | last post by:

I just changed my Access 2002 database to a SQL Server ADP project. I had a form where the user entered a value into a text box and when a command button on the form was clicked a Report was...

Microsoft SQL Server

Report Problem

by: Lloyd Stevens | last post by:

I'm trying to create a report from two queries, one query displays which customers bought a particular product, the quantity and price using the "Enter productID" as parameter While the other is...

Microsoft Access / VBA

Print Form to Report

by: Simone | last post by:

Hi, I'm a DB newbie and I've been having issues trying to print the record I am viewing in a form to a report. I have looked in groups all over and they all say to try basically the same thing...

Microsoft Access / VBA

Problem getting new record from subform to appear on subreport

by: kkrizl | last post by:

I have a form that displays general information about an alarm permit location. There's a subform that shows detailed information about burglar alarms that have gone off at the location. When a...

Microsoft Access / VBA

Problem with Crystal Report

by: Victor | last post by:

Hi, i have a simple report with 1 parameter and i want to send it to the printer without use the crystalreportviewer but it shows me an exception "Parameter value is needed",maybe the problem can...

C# / C Sharp

Show a print preview of Access reports from VB.NET?

by: Dean Slindee | last post by:

Anybody written code in VB.NET to: 1) show a print preview window of reports already written and stored in an Access 2002 database; or 2) execute the print of a report stored in an Access 2002...

Visual Basic .NET

Repetitively asked for parameter value

by: yoursteveis | last post by:

Dear all, I have created a main report (for monthly purchase summary) and a sub report (for monthly sales summary). I have linked main report with a parameter query (i.e. purchasesummary1) and...

Microsoft Access / VBA

Print a report 3 times with 3 different fields visible

by: Studiotyphoon | last post by:

Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing