Coding for Date Function

[ElectraFire]

Hey All,

I am trying to code for a button that should do something like this... BELOW

I am not quite sure how I would create the coding that would take the from a list of tapes, the last 3 that had been used, based on their date??? If someone could help or point in the right direction that woudl really help.

ElectraFire

'should be a call procedure or show
'the calculations
'Calcultions should be based on
' listCount -1 for total, and take the last 3 tapes
' that have the oldest dates.
'

'If Last Friday in month
' Display
' msgBox "need new tape"
'
'Else
' If Monday To Thursday
' Display Tapes that should be used
' The last 3 tapes last used
' Then display info in form
' Else
' If Friday
' Display tapes
' to be used. Maybe 2 tapes
' The last 3 tapes last used
' Then display info in from
' Else
' msgbox "Error"
'End If

 

[kphu]

Hi,

Are you refering to word, excel, etc?