Sequential Numbering

[Guest]

Hello

I have a query with multiple fileds. I would like to add a squential number at the end of a value and have the number start over for the next item

Exampl
Current: What I wan
AM01100 AM01100-
AM01100 AM01100-
AM01120 AM01120-
AM01120 AM01120-
AM01130 AM01130-
AM01140 AM01140-
AM01140 AM01140-
AM01140 AM01140-

How can I achieve this

Daniel

 

[Duane Hookom]

Which AM01100 value is the first and which is the second? Is there another
field that provides a value that establishes an order?

--
Duane Hookom
MS Access MVP

Hello,

I have a query with multiple fileds. I would like to add a squential

number at the end of a value and have the number start over for the next
item.

 

[Guest]

Duane

The table that provides these part numbers is a criteria table. As such each time the user inputs a criteria it is associated to a part number. Thus the part number will be a function of the number of criterion associated to it

Does this help

Daniel

 

[Duane Hookom]

Your reply only confused me more. I'm not sure what the criteria has to do
with anything. I asked if there was any value that determines the order of
the records.

--
Duane Hookom
MS Access MVP

Duane,

The table that provides these part numbers is a criteria table. As such

each time the user inputs a criteria it is associated to a part number.
Thus the part number will be a function of the number of criterion
associated to it.

 

[Guest]

No, there is no specific order to the information.

 

[Duane Hookom]

Are the records unique? Like is there a primary key? Could you post the
table structure and the sample output?

 

[Guest]

Hi Duane

I have the following tabl

Part number Description Test Objective Defect Classificatio
************************************************************************
00001 drop the part elevation 30".. .... .... ....
00001 impact Test drop a 25lb... .... .... ...
00001 color abrasion... ... .... .... ...
00002 light emission ... ..... ...... ...
00002 another test ... .... ........ .....
00003 yet another test ...

Now let me explain a little. Each part can have a multitude of criteria entered but will never have the same description twice for an individual part number. Although the same description will occur of different part numbers. Therefore I thought that the counter needed to be linked to the description column of my table. The .... are any text input by the user, and may be the same as for other criterion (not necessarily unioque). The only unique field (for each part number) is the description field

Also, this table houses all of the criterion for all of my part and I use a query to link this table to a secondary table which permits me to filter for only the parts that relate to one specific project (but I don't beleive this has much impact for what I am trying to do)

Here is an example of what I would like as a resul
Part number Description Test Objective Defect Classificatio
************************************************************************
00001-1 drop the part elevation 30".. .... .... ....
00001-2 impact Test drop a 25lb... .... .... ...
00001-3 color abrasion... ... .... .... ...
00002-1 light emission ... ..... ...... ...
00002-2 another test ... .... ........ .....
00003-1 yet another test ...

Thanks for your help

Daniel