Make Table as per Date Range

Hi all,

The idea I  am trying to develop is the following:

I have a table of clients
Each has a status eg StatusA, StatusB, StatusC.
Each Client has a Date of Commencement (DOC)

I am trying now to create a temporary table whereby when I enter a date range in a form I want all clients that are StatusA and whos DOC falls within the Date Range entered to be assigned as "New"

I am attempting it by creating a make table query but I am having difficulty in creating the necessary expression to assign the client.

Grateful for assistance.