Assess: How to make a list in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MCLennox - 20 May 2005 14:06 GMT

How do you make a list in either a query or in a table
Ex:
1. Directions
2. Preferential seating
3. Fm system
4. etc.

Reply to this Message

Duane Hookom - 20 May 2005 14:20 GMT

Could you explain what you mean by "make a list"?

Signature

Duane Hookom
MS Access MVP

> How do you make a list in either a query or in a table
> Ex:
> 1. Directions
> 2. Preferential seating
> 3. Fm system
> 4. etc.

Reply to this Message

MCLennox - 20 May 2005 14:45 GMT

As I had shown in my example:
1. example
2. example
3. example

I would like to make a list like above examples.

> Could you explain what you mean by "make a list"?
>
[quoted text clipped - 4 lines]
> > 3. Fm system
> > 4. etc.

Reply to this Message

Duane Hookom - 23 May 2005 04:32 GMT

Create a table with two fields: TheNumber, TheText. Then type in your
values. You will then have something like your example.

Signature

Duane Hookom
MS Access MVP

> As I had shown in my example:
> 1. example
[quoted text clipped - 11 lines]
>> > 3. Fm system
>> > 4. etc.

Reply to this Message

MCLennox - 23 May 2005 16:28 GMT

Thank you I got it to work!

Marlene

> Create a table with two fields: TheNumber, TheText. Then type in your
> values. You will then have something like your example.
[quoted text clipped - 14 lines]
> >> > 3. Fm system
> >> > 4. etc.

Reply to this Message