How to create Current/Superseded Record and Hyperlink

[Chard14]

Hello, I want to know how can i create that will show that an added record is a current revision and the previous same record is superseded. For Ex.

Description, Rev Status Hyperlink
General layout, 01 Current eCopy
General layout, 00 Superseded 

And I want to know how to hyperlink multiple records with different filename the ecopy of it but the Current Status only.

Hope somebody will help me...thanks

[ajetrumpet]

generally, you will never store information from an 'old version' of records. If you do want to though, google something like "ms access archive records". there are archiving systems in place I'm sure, but I personally have never used them.

of course, you can also do it yourself simply by writing a little bit of code.

[LillMcGill]

Add a DateEntered field and set the Default value to Now().

"And I want to know how to hyperlink multiple records with different filename the ecopy of it but the Current Status only"
I don't know what you mean, but it doesn't sound good.

[Chard14]

=IF(A11=A10,"Superseded","Current") ===> This is my formula in Excel
I want to know the equivalent MS Access formula.


=IF(L11="Current",HYPERLINK("C:EFile"&"\"&J11&"\"&A B11,AB11),"") ====> My formula in Excel, I want to know the equivalent MS Access Formula.

The Current and Superseded are automatic if new records are added and sort.The hyperlink are automatic with different filename.
I have thousand of record to be in place and would like to use MS Access.

Help!Thanks.

[NoellaG]

Hi Chard,

the equivalent for the "if"excel function in Access is the Iif function (immediate if)

gr
NG

[Chard14]

@NG
I know the Iif...but how about the condition (A11=A10,"Superseded","Current")

[NoellaG]

Hi,

that depends on your database structure. A database doesn't have cells, but records and fields, so you will probably have to compare the content of 2 fields and put the fieldnames in place of the cell addresses.

grNG