473,586 Members | 2,546 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

using report to extract unique values

140 New Member
Hi,

form name: person_wise

i ve insert a option group.
framename=date tracker
option 1= track by date
option 2=by task....( not implemented now)

preview command button is there.
when i click that, it ask for taskstartdate and enddate and displays a report accordingly like 10/11/06 to 15/11/06. exact date result. but i want unique person name and his taskstartdate and taskenddate.

i ve given the criteria in startdate field in report as between[taskstartdate]and [taskenddate] do i ve to give for person also like this or else

tell me yeah
Nov 22 '06 #1
2 1519
willakawill
1,646 Top Contributor
Hi,

form name: person_wise

i ve insert a option group.
framename=date tracker
option 1= track by date
option 2=by task....( not implemented now)

preview command button is there.
when i click that, it ask for taskstartdate and enddate and displays a report accordingly like 10/11/06 to 15/11/06. exact date result. but i want unique person name and his taskstartdate and taskenddate.

i ve given the criteria in startdate field in report as between[taskstartdate]and [taskenddate] do i ve to give for person also like this or else

tell me yeah
Hi. Take a look at the keyword DISTINCT. It might be what you have been looking for.
Nov 22 '06 #2
NeoPa
32,566 Recognized Expert Moderator MVP
i ve given the criteria in startdate field in report as between[taskstartdate]and [taskenddate] do i ve to give for person also like this or else
I think you're along the right lines here.
If you want the report to show details for only one person then you do need to restrict the output to that one person.
The Filter is the best place for this.
Nov 22 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2504
by: Megan | last post by:
quick summary: i'm having problems trying to group fields in a report in order to calculate percentages. to calculate percentages, i'm comparing the results from my grouped fields to the totals. first, let me say that this is a really long post. i wasn't sure how much information/ background to provide, so i thought more was better than...
1
1581
by: Ken Smith | last post by:
Can someone tell me how to do a compare of two different fields in two different tables to generate a report which will tell me what values are missing? I have two tables, one is the values that should have gotten imported into a system and the other is the ones that are actually in there. There's 250 some odd that didnt make it (out of...
11
6579
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am...
0
2373
by: Andrew | last post by:
Hello, I am trying to create a chart whose underlying query is linked to 2 combo boxes on the same form. I want to pass the values from the combo boxes into the chart query to allow the chart data to be manipulated easily. The combo box uses "Row Source Type" = Table/Query. The "Row Source" references a query to extract a distinct list...
5
6759
by: Michael Sperlle | last post by:
Is it possible? Bestcrypt can supposedly be set up on linux, but it seems to need changes to the kernel before it can be installed, and I have no intention of going through whatever hell that would cause. If I could create a large file that could be encrypted, and maybe add files to it by appending them and putting in some kind of delimiter...
5
3350
by: David L. | last post by:
I'm running into a frustrating problem. ASP.NET 2.0 web application, against SQL'05, I'm trying to run a report against a 'table provider' (query) that excutes well within SQL MGT studio, and within the data environment. However, when the report is executed in a web report viewer, the report engine comes back with: An error has...
4
2925
by: LF | last post by:
Hello, I have a database with a table of projects and a table of tasks (each project can have multiple tasks). I have a report that has a group header for the project name, etc., and then the tasks appear in the Detail section. Is it possible to have the project information in the group header show up on the report even if there are no...
1
3700
newnewbie
by: newnewbie | last post by:
Hi, Could somebody please help me with VBA code to count unique values in a Report? Report is based on a query that has grouped values. Basically, I would like to use formula =COUNTUNIQUEVALUES() in the report form. Is it possible? Thank you! Lena
5
1843
by: Brett Barry: Go Get Geek! | last post by:
Hello, Can someone please paste VBA code and how I would go about doing this?: I have a customer table with over 6000 duplicates in the field called "Customer". While the customer names may be duplicates the data in other fields is different. I would like to import all of the customers including the duplicates; however, the program I am...
0
7915
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7841
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8204
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7965
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5392
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3869
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2345
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1452
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.