For example, a field might require a fax number, but some of your customers might not have fax machines. To add any fields that you want to include in the query design, drag the additional fields to the query design grid. This was last published in May Related Resources. The following illustration shows an update query that returns all the assets purchased after January 5, and changes the location to "Warehouse 3" for all the records that meet that criterion. This procedure shows you how to change a select query to an update query. Date Uses the Date function to return all records containing today's date. On the Design tab, in the Results group, click Run.