So there is a field consiting of 4 numbers on the database.
You need to create a function using the MID function to spread the number and then the IIF function to check if it is a number. Then SUM your answer to display that you got, 1+1+1+1 = 4
or if not 4, it is invalid.
i
I hope all's well with you.
I see you'r looking for a developer proficient in Ms Access/VB.
Really all my projects here I've developed for Ms Access/Excel/VB projects.
I'm programmer/mathematician since 1979.
I'm developing with Access/SQL/VB/Excel since 1997.
I can write a function using IIF and Mid using MS Access .
I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work.
Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details.
Thank You and Regards,
Zura
Please pick me! I'd love to work with you on this! I'm great at Access!
Relevant Skills and Experience
I've been writing projects in access since 1997. I have experience with vba, SQL, and all aspects of access use.