Search results
-
D
Append Query in a Form
Is this something Access can't do then? The table contains over 11K records...the user is asked to enter the Number of Days to Review, and the form opens showing only the records for the next X days [example 120 records out of 11K]. I review them, and now I click the APPEND Query button to... -
D
Append Query in a Form
Ok...I've got it now so that the data in the Form is only the data I need for the Append query. So how do I write the query that will execute in the form as a button to only append the records that show in the form? I think I need a WHERE statement that points to the Open FORM of records... -
D
Append Query in a Form
I've read the other posts, but still can't see how to do this. I have a form and opens up a datasheet to a table. I then use the date picker to limit the recordset showing in the form. Once I review the records for the day, I now want to use a button to do the following: Append 3 of the...