Auto number in a query

[BarnetBoy]

I'm an access newbie.... Please help! I want to create a query that:

1. Only pulls in records from another query where the value in a given field is "A".
2. generates a number (1,2,3 etc..) in a an entirely new field for each record that it pulls in.

This might be simple stuff to many of you DB experts but it would help me enormously if some-one could help

 

[Fizzio]

1. Only pulls in records from another query where the value in a given field is "A".

Put the value you want to filter on into the Criteria box in the Query Designer grid (QBE grid) under the field you want to filter.

2. generates a number (1,2,3 etc..) in a an entirely new field for each record that it pulls in.

A little more tricky. This Example Should help you along.

hth