matching fields to have same run number

[Boomshank]

Hello,

I have a table of our customer orders which contains the following fields:

Client Code
Client Name
Output
Date
Count
Post Code (Ascending)
Run No.

Different clients share the same post code so what i would like to do is on each date, every client that shares the same postcode should be given the same run No. Then at each change in post code the run no. is to increase by 1.

so if on the 1st June 3 clients have the same postcode all three should be given the same run number. i.e Run1, then the next set of postcodes need to be run2

Is this possible? If so how do i go about doing it?

Many Thanks

 

[Boomshank]

What i did to solve this was

Create a new table - CustomerAddress which held the ClientCode and PostCode.

I created a relationship between my CustomerOrder and Address tables using the ClientCode.

I then created a query that shows the orders and postcode which i called GetPostcode

Next i created a query that shows all of the duplicates for date and postcode from my GetPostcode query. I then appended this data to a new table which i called RunNo and set the RunNo. field to Autonumber.