I have created a two page form in Access to acquire user input on patient surgical infection outcomes. it has about 30 fields to be entered yes/no or with a comment.
I have a Table with a field to accept the data from every field on the form,
Form Field= ChkVomit Y/N format Table Field = Vomit Y/N format
What would the syntax be to Insert Into the TABLE from the FORM fields?