hi kindred169
would the use of the midstring function solve your issue with your week numbers? i am assuming that your numbering scheme is FW1, FW2 ... FW52. if it is then insert your variables into this : Mid(string, start[, length]) where string is your FW, start is the position to begin...
At any given time, a person may only hold one type of annual membership but it can be changed to another type the next year and the new amount will be charged.
Thanks for your input Maq, it made me realize something that I had overlooked in another area of the database.
This appears to be...
I have to make modifications to an existing database and would like to have other opinions prior to working on it.
The old structure for the Member_Type table was:
memID - autonumber (PK)
memType - text (duplicates=no)
cost - monetary (duplicates=OK)
Back then, any type of membership could be...
Can anyone tell me how to modify the Revision Number and or the Total Editing Time as seen in the File Properties of an Excel 2000 File?
Using these properties seems more practical than relying on the "Last Saved" property when making frequent modifications to a file.
[hourglass]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.