Incrementing a number for each row

D

DontKnow

Hi Guys,

I need some help in numbering incremental rows for a particular project.

For instance if I have 3 records I am trying to have the name of the
project, a slash and then the nuber of the record.

ie.
RecordNo: Type projectRisk
Record1 Risk 02033/1
Record2 Risk 02033/2
Record3 Risk 02033/3

You see under Project Risk. This is what I am trying to do!
I am able to produce the autonumber of rows but not the 02033/1,2,3 etc All
I am able to get is 02033/1 for all three records using the Default entry in
properties
..
I have tried for several days but to no avail!!

how can I do this??
I am using a subform in datasheet view!!

Cheers
 
T

Tom van Stiphout

On Wed, 3 Dec 2008 17:36:01 -0800, DontKnow

Why is this important? Unlike the perhaps more familiar Excel
environment in a relational database one hardly ever needs sequential
numbering like this. It often points to a misunderstanding of how
things work in a db as opposed to a spreadsheet. If you could
elaborate, perhaps we can suggest alternatives.

-Tom.
Microsoft Access MVP
 
D

DontKnow

Its for a risk database so that when somone looks at a risk register someone
can see the number of a risk. Depending on the allocated risk whether it is
high medium or low is transferred to another table. This allocated number
allows the managers to easily see from where the risk came from and from
which project.

ie. 02008/1 refers to a risk from maitland and is the first risk etc

I hope this is clearer!!

Cheers
 
M

Mike Painter

DontKnow said:
Hi Guys,

I need some help in numbering incremental rows for a particular
project.

For instance if I have 3 records I am trying to have the name of the
project, a slash and then the nuber of the record.

ie.
RecordNo: Type projectRisk
Record1 Risk 02033/1
Record2 Risk 02033/2
Record3 Risk 02033/3

You see under Project Risk. This is what I am trying to do!
I am able to produce the autonumber of rows but not the 02033/1,2,3
etc All I am able to get is 02033/1 for all three records using the
Default entry in properties

I would say that the project should be in a master record and the risks in a
related table

ProjectRisk would be calculated with ProjectRisk:projectID &"/"& RiskNumber.
in a query.

If Is Null RiskNumber then
RiskNumber = 1
else
RiskNumber = DMax ("RiskNumber", "RiskNumberTable", "ProjectID = " &
someField) + 1
End If
 
D

DontKnow

Hi Mike,

Thanks for your reply!!

Where should I place this code??

Should I have a unbound or bound text box??

Please advise!!

Cheers,

thankks again for your help!!

This is quite difficult!!
 
M

Mike Painter

ProjectRisk would be calculated with ProjectRisk:projectID &"/"& RiskNumber
in a query.
Build the query and add the above to as a field in the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top