Question: 3 . Create a new query in Design View and individually select all of the fields from the Surveys table. Add criteria to select only
Create a new query in Design View and individually select all of the fields from the Surveys table. Add criteria to select only those records with any date in July Change the query into an Append query and select the June table to append the records into. Run the query, which should append records into the June table. Save the query with the name AppendJuly and then close it Rename the June table to be JuneJuly and then open it to review all records as shown in Figure Close the JuneJuly table. Hint: The month of July has days. Use the AND keyword in your criteria.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
