Right I need to create a log for every ID for each day. Every day there is three meals, breakfast, lunch and dinner. I wrote a VBA code for a button on click event to append date but it is not working.
Private Sub cmdAdd_Date_Click()
Dim strSQL As String
strSQL = "INSERT INTO Food_Distribution...