473,395 Members | 1,941 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

I have a problem with my access report

6
I have a someone that is listed in my reports twice because they have two r-id. I need to take the data from both r-id and combine them? For example :


Reggie Smith 700 700
Reggie Smith 100 100


Needs to be

Reggie Smith 1600
Jul 23 '07 #1
4 1218
missinglinq
3,532 Expert 2GB
I'm almost afraid to ask this, but what unique identifier do you have for each person? And to clarify

I have a someone that is listed in my reports twice because they have two r-id.
Are you really talking about a single person or do you have multiple people with more than one r-id?

Welcome to TheScripts!

Linq ;0)>
Jul 23 '07 #2
twink
6
I'm almost afraid to ask this, but what unique identifier do you have for each person? And to clarify

Are you really talking about a single person or do you have multiple people with more than one r-id?

Welcome to TheScripts!

Linq ;0)>
Yes for instance Reggie Smith has two unique indentifiers. One is R5066 and the other is R5077. Since my query is ran by the r-id he comes up on my reports twice. I want him to show up once with all data of both r-id. For example

R5066 Reggie Smith 700 100 = 800
R5077 Reggie Smith 700 100 = 800

Report needs to look like

Reggie Smith 1600
Jul 24 '07 #3
missinglinq
3,532 Expert 2GB
Are you really talking about a single person or do you have multiple people with more than one r-id?
You didn't answer the above question! Is this one single person who's managed to get multiple "unique identifiers" or do you have a number of them? And how do you know that R5066 Reggie Smith and R5077 Reggie Smith are one and the same person?
Jul 24 '07 #4
twink
6
You didn't answer the above question! Is this one single person who's managed to get multiple "unique identifiers" or do you have a number of them? And how do you know that R5066 Reggie Smith and R5077 Reggie Smith are one and the same person?
Yes it is one person who happens to have multiple unique indentifiers. I know that Reggie Smith is the same person because that is what was told me to me by the person I set the data base up for. They stated that they needed him to have two unique indentifiers for business purposes.
Jul 24 '07 #5

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

Similar topics

7
by: Foxster | last post by:
in access i have two tables (tblplayer, tblpoints) in tblplayer i have field totalpoint (number) in tlbpoints i have field pointgame (number) the two files are related via idplayer now i made a...
16
by: David Lauberts | last post by:
Hi Wonder if someone has some words of wisdom. I have a access 2002 form that contains 2 graph objects that overlay each other and would like to export them as a JPEG to use in a presentation....
2
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name>...
4
by: sherkozmo | last post by:
SQL2000 - AccessXP I built an adp file with a stored procedure from SQL as follows: SELECT * FROM Z_mis_sjk_job_code_access WHERE job_code=@JobCode UNION ALL SELECT * FROM...
2
by: Jonathan Goldman | last post by:
Hi- I have a relatively simple report that I open in an Access '97 VBA procedure, using the Docmd.OpenReport "rptName", acViewNormal syntax. The problem is that doing this usually crashes...
5
by: Steve Patrick | last post by:
Hi All You guys are my last hope, despite spending money on books and hours reading them I still can not achieve the results I need. I have designed a database in Access 2000 based on 1 table,...
2
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...
8
by: babyangel43 | last post by:
Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
1
by: Dennis Hartmann | last post by:
ACC 97 - Report with multiple grouping levels. Report footers have text controls with controlsource: "=Avg()". The report's Recordsource was changed so field1 contains null (instead of zero) for no...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
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,...
0
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...
0
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...

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.