query design to take out repeating IDs (1 Viewer)

[saledo2000]

Hi everyone,
I have Two tables with a relationship Reg_ID to FM_ID one to many. When I create a query I get good result. But is there a way to take out repeating IDs from query somehow. Sample is attached.
Thank you.

 

[June7]

No. This is how query joining tables is supposed to work. If you don't want to show repeats, build a report. Textbox has Hide Duplicates property.

 

[plog]

Probably, but why? What's the big picture? What do you want to use this query for?

Also, your data and description aren't 100% fleshed out:

But is there a way to take out repeating IDs from query somehow.

You have 2 ID fields (Reg_ID, FM_ID), but your sample data kinda treats Reg_ID as the one you want to eliminate duplicates from. I say "kinda" because you have 2 records on the right side that have Reg_ID=1013, so that too is a confusing element.

 

[jdraw]

saledo2000,
Kindly tell us about your database in simple terms. As others have asked What is the big picture?
Why are there duplicates? Shouldn't prevention of duplicates be investigated rather than removing them once stored?

 

[saledo2000]

Probably, but why? What's the big picture? What do you want to use this query for?

Also, your data and description aren't 100% fleshed out:



You have 2 ID fields (Reg_ID, FM_ID), but your sample data kinda treats Reg_ID as the one you want to eliminate duplicates from. I say "kinda" because you have 2 records on the right side that have Reg_ID=1013, so that too is a confusing element.

Yes I showed only part of my query. The rest of data are the names and surnames which I do not want to show. If is possible to do it would appreciate your expertise. Thank you.

 

[saledo2000]

saledo2000,
Kindly tell us about your database in simple terms. As others have asked What is the big picture?
Why are there duplicates? Shouldn't prevention of duplicates be investigated rather than removing them once stored?

Hi
I have explained relationship between fields from two tables. First table is Reg and the other one is FM table. I guess it is possible but I am a beginner in access. Thank you.

 

[plog]

Big picture. What's the ultimate end goal?

Queries are steps toward a goal. People export their data, they build reports and forms using them, they use them to look up individual pieces of data. A query is not the end. So, what is the end goal. You are not giving us enough to go on.

Explain what your database as a whole is for, then explain what this one query will allow you to do.

 

[jdraw]

yes, you are a beginner. Just think of what you might need to provide to a developer you hired to fix your issue OR think of what you would need if someone asked you to fix a problem you were not familiar with.
We need context.

 

[June7]

Did you read post # 2?

 

[isladogs]

Please post your query SQL