Home
|
Contact Us
|
FAQ
|
Search & Site Map
|
Link to Us
Sign In
|
Join
|
Other 45 Sites in Network
Home
Discussion Groups
Forms
Forms Programming
Queries
Modules / DAO / VBA
Reports / Printing
Macros
Database Design
Security
Conversion
Importing / Linking
SQL Server / ADP
Multiuser / Networking
Replication
Setup / Configuration
Developer Toolkits
ActiveX Controls
New Users
General 1
General 2
Access Directory
Tools
Tutorials
User Groups
Related Topics
SQL Server
Other DB Products
MS Office
More Topics ...
MS Access Forum
/
Queries
/
December 2005
Tip:
Looking for answers? Try searching our database.
Can I set a querry to omit instances of repeat ID numbers
Thread view:
Tree View
List View (postings sorted by date)
Single Message View
Enable EMail Alerts
Start New Thread
Thread rating:
welshgirl
- 08 Dec 2005 11:36 GMT
I have allowed a database to use duplicate IDs
I need to set up a query to omit all the instances of duplicate IDs
can anyone help please?
Reply to this Message
Jeff Boyce
- 08 Dec 2005 13:39 GMT
Queries have properties, including "Unique Values". If you set this to
"Yes", does that return only unique IDs?
Signature
Regards
Jeff Boyce
<Office/Access MVP>
> I have allowed a database to use duplicate IDs
> I need to set up a query to omit all the instances of duplicate IDs
> can anyone help please?
Reply to this Message
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread
©2008 Advenet LLC
Privacy Policy
-
Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.