Table fields

[Radhika]

I have a table in which one of the fields is called 'Objectives'. I want all
the objectives in the field to be ordered with numbers. For example, in forms
veiw I want the data in the field to look as follows:

Objectives 1. To...
2. To.....
3. To......

Is there any way in which I can automatically program this?

Thankyou,
Radhika

 

[Jeff Boyce]

Rather than embedding more than one fact per field ("Objective" AND "sort
order"), consider adding another field that would hold an integer. You'd
use that added field to allow you to sort the objectives.

Use a query to come up with a sorted list of objectives.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bill Mosca]

Is this what you are after? It numbers each record.
SELECT Customers.CustomerID,
Customers.CompanyName,
(SELECT Count(CustomerID)
FROM Customers c
WHERE c.CustomerID <= Customers.CustomerID
) AS RowCt
FROM Customers