By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

I have a problem with my access report

P: 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
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
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

P: 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
Expert 2.5K+
P: 3,532
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

P: 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

Post your reply

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