How do I itemize all of the numbers within multiple sets of range

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

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 / Modules / DAO / VBA / November 2006

How do I itemize all of the numbers within multiple sets of range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BusyDad - 23 Nov 2006 00:05 GMT

I have thousands of ranges of documents that I need to determine all of the
individual numbers within the ranges. In Access is there a sql statement
that I can use.

Reply to this Message

Damian S - 23 Nov 2006 00:09 GMT

Hi BusyDad,

To find out unique numbers from a table, try:

select distinct DOCUMENTNUMBER from TABLENAME

Is that what you were after? If not, post a bit more info.

Damian.

> I have thousands of ranges of documents that I need to determine all of the
> individual numbers within the ranges. In Access is there a sql statement
> that I can use.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

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.