Database help on renaming please see attachment

TheSpecialist

New member
Local time
Today, 07:44
Joined
Sep 3, 2015
Messages
7
Hi I need some help

She wants me to figure out how to translate the above grid into rows in your table that will convert scope and severity values into letters values.

Please see attachment

Thank you

Erika
 

Attachments

  • 2015-09-16 (3).jpg
    2015-09-16 (3).jpg
    98.3 KB · Views: 105
to me, its a simple append query.
user clicks a button, the sql will write the letter clicked

sSql = insert into table ([letter]) values ('" & btnValue & "')"
docmd.runSql sSql
 

Users who are viewing this thread

Back
Top Bottom