How do i number my records in Access? 1

[Akart]

Hello,

I am trying to count the number of orders sent to a customer and number the records. There is one record for each order.

Customer A had 4 orders 1,2,3,4
Customer B had 3 orders 1,2,3
Each record has a package number field that needs to have the correct number.
This is so the users can see while looking at a record, that this is the customers 2nd order etc.
Please help!

Akart

 

[Chalco]

select count(*) from order where customer=your_customer_id

This could be put into the overall select as follows:-

select c.name, c.address, c.id, (select count(*) from orders where orders.customer_id = c.id) as Nf_Orders from customers c where xxxxxxxxxx