Find first and last element of a column in a table

  • Thread starter Christos via AccessMonster.com
  • Start date
C

Christos via AccessMonster.com

Dear friends

I would like to find the first and the last element of a record in a table.
Is there any possibility especially if yoy have not promary key?

Christos
 
D

Douglas J. Steele

What does "first" and "last" mean in your context? Rows in a relational
database (such as Access is) do not have a known order.

You could use the Min and Max (or DMin and DMax) functions.

Why don't you have a primary key, though? All tables should.
 
C

Christos via AccessMonster.com

Dear Mr Steel

I inserted a primary key (number id =1..100). I need to see the elements
wwith id =1 and id =100.
How I can do that???
 
A

Allen Browne

The message was posted to newsgroup comp.databases.ms-access via
AccessMonster.com by "Chrisos via AccessMonster.com".

You don't need to use that website to read the response. You can use any
newsreader, such as Outlook Express, Netscape Communicator, or Free Agent.
You can also find the group on the web at:
groups.google.com
 
Top