How to create a query to generate a record.

You need to tell which record you wish to create - in which table and with what data, and if this data are to be input by the user.

Well a simple insert query would look like the following when run from the SQL view in Access

INSERT INTO yourTableName (Field2integer, Field3Text, Field4Date)
Values (1, "test", #11/21/2019#)

Select all Open in new window

Note that I did not include Field1, which in my case is always an Autonumber and gets created automatically.

if you want to do this from code, you have to make a couple of minor modifications, replacing the quotes with single quotes and wrapping the entire string in quotes, like this:

Dim strSQL as string
strSQL = "INSERT INTO yourTableName (Field2integer, Field3Text, Field4Date) " _
       & "Values (1, 'test', #11/21/2019#)"
Currentdb.Execute strsql, dbfailonerror

Select all Open in new window

You can also insert NULLs into fields which accept them.

INSERT INTO yourTableName (Field2integer, Field3Text, Field4Date, Field5AllowsNulls)
Values (1, "test", #11/21/2019#, NULL)

Select all Open in new window

HTH
Dale

Sorry, don't have time to update the file, did you look at what John gave you?

Again, as we can't read your mind: Add a record with what data, and are these data to be input by the user?